PRB: Number of Records IMPORT/EXPORTed to Spreadsheet Differs

• Microsoft FoxPro for Windows, versions 2.5, 2.5a, and 2.5b
• Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, 2.5a, and 2.5b

SYMPTOMS

If you use the COPY TO or EXPORT TO commands to export a database to a spreadsheet file type, and then use the APPEND FROM or IMPORT FROM commands to import that spreadsheet back into a database, the number of records FoxPro reports copied (during the export) is one less than the number of records it reports added (during the import).

CAUSE

When you are copying to a spreadsheet file type, the COPY TO and EXPORT TO commands add an extra record (row) to the beginning of the destination file (spreadsheet). This record contains the names of the database fields and is not included in the FoxPro message that reports the number of records copied, since it is not an actual database record.

However, when the APPEND FROM or IMPORT FROM command imports the records (rows) from that same spreadsheet back into a database, the extra record containing the field names is treated like any other record in the spreadsheet, so FoxPro includes it when reporting the number of records added/imported.

MORE INFORMATION

This information applies to the following file types:

   DIF, MOD, SYLK, WK1, WKS, WR1, WRK, XLS

Steps to Reproduce Behavior

1. Start FoxPro.

2. Create and run a program with the following code:

         SET STATUS ON    && So you can see all messages on the desktop
         CREATE TABLE test (charfld C(20), numfld N(10))
         INSERT INTO test (charfld, numfld) VALUES ('Chris Tester', 1234)
         COPY STRUCTURE TO copytest.dbf
   
         COPY TO copytest.xls TYPE XLS
          * Message on Desktop: 1 records copied
         EXPORT TO exp-test.xls TYPE XLS
          * Message on Desktop: 1 records copied
   
         USE copytest.dbf
         APPEND FROM copytest.xls TYPE XLS
          * Message on Desktop: 2 records added
   
         USE
         IMPORT FROM exp-test.xls TYPE XLS
          * Message in Wait window: 2 Records Imported
   
   

   exported and first and record and field and names