Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/103355

From BetaArchive Wiki
Knowledge Base


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