General information
Category:
Coding, syntax & commands
>I am trying to export a VFP table to and Excel worksheet and am running into a problem in that the resulting XLS file seems to have a limit to the number of rows that can be imported. If I use the following command: COPY TO test XLS the resulting worksheet does not contain all of the table's records. Does anyone know of a solution to this problem?
Older versions of Excel only had 16K rows, Excel97 has 64K rows.
If your table has more rows, then you're out of luck. You'd have to manage multiple worksheets with 64K rows each. Although, if you have THAT much data, what are you doing dumping it directly into excel? (Once it gets to excel, each "cell" has font/border/formula/etc. properties which increase the size of each piece of data. On most machines, opening 64K records in Excel will be painfully slow, especially compared to the access time in VFP.)
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only