Knowledge Base |

# EXPORT/ COPY TO Commands Don't Work with Entire Tables

Article ID: 103355

Article Last Modified on 12/3/2003

APPLIES TO

- Microsoft Visual FoxPro 3.0 Standard Edition
- Microsoft Visual FoxPro 3.0b Standard Edition
- Microsoft FoxPro 2.5b
- Microsoft FoxPro 2.5a
- Microsoft FoxPro 2.5b
- Microsoft FoxPro 2.0
- Microsoft FoxPro 2.5b for MS-DOS
- Microsoft FoxPro 2.5a
- Microsoft FoxPro 2.5b for MS-DOS

This article was previously published under Q103355

## SUMMARY

The EXPORT/COPY TO commands export or copy only as many records as are allowed by the type of file chosen to export or copy to.

## MORE INFORMATION

Lotus 1-2-3 files (.WK1, .WKS) have a limit of 8192 records. When you try to export or copy a FoxPro table with more than 8192 records to a Lotus 1-2-3 file, FoxPro transfers only the first 8192 records in the table to the .WK1 file because this is the established limit of this type of file. Similarly, only 16,384 records can be export or copied to a Microsoft Excel (.XLS) file.
Listed below are the limits for all the EXPORT/COPY TO file types:

       Type              Record limit
       ------------------------------

       DIF                  65,534
       MOD                  16,383
       SYLK                  9,998
       WK1(S)                8,191
       WR1(K)                8,191
       XLS                  16,383

### Sample Code

       SET STATUS ON
       USE <x>
       * where <x> is a table with less than 8192 records.
       GO TOP
       * Note that the record pointer is on record 1.
       EXPORT/COPY TO expfile.wk1 TYPE WK1
       * Note the record pointer is now at EOF.
       USE <y>
       * where <y> is a table with more than 8192 records.
       GO TOP
       * Note that the record pointer is on record 1.
       EXPORT/COPY TO expfile.wk1 TYPE WK1
       * Note the record pointer is now on record 8192.

Additional query words: vFoxWin FoxDos FoxWin third party 3rd-party

Keywords: KB103355