Microsoft KB Archive/103355

= 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  * where  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  * where  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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.