Simple solution: Upgrade to VFP 8. This enhancement
in VFP 8 is the best solution to your problem (from the
help file):
Number of Rows for Exporting Data Cursors
Visual FoxPro raises the maximum from 16,384 to 65,535 rows when exporting a data
cursor to an Excel spreadsheet. The new limit includes one row reserved for the
field header. For more information, see EXPORT Command, COPY TO Command, and The
Process of Exporting Data.
>Hello to all,
>
>Actually I have a problem with the export in VFP : When I try to export a dbf file from VFP to Excel, the number of record exported is stopped at 16383 records and that, for any size of the export file. from 100K to 5 mb.
>
>Thank for your help