Quote:
> Hi,
> I am exporting data from a table on vfp 6.0 to an excel
> file using "copy to type xls format", my table has 31152
> records but when I export it to excel only 16383 records
> are being transferred.
Hi Sandeep.
I think the 16383 record limit is an excel limitation. The following is from
the help file of vfp 8 under the copy to xl5 command:
"Creates a Microsoft Excel version 5.0 workbook file. Each field from the
currently selected table becomes a column in the spreadsheet, and each
record becomes a row. If you do not include a file extension, an .xls
extension is assigned to the new workbook.
Note Though you can export a maximum of 65,535 rows, which includes one
row reserved for the field header, versions of Excel earlier than 8.0 (Excel
97) display only the first 16,384 rows and cannot import files containing
more than 32,767 rows."
I think that earlier version of vfp had a limitation that was below the
65535 rows of vfp 8, but I cannot recall the exact number. Maybe someone
else does?
Regards,
Eyvind.