General information
Category:
Coding, syntax & commands
Hi,
I've come across this problem too. COPY TO (cFileName) XLS only seems to copy 16384 rows ( 16383 rows plus the 1 row of field headers ). What I do is either copy the records to a FOX2X dbf or to a CSV file. Either of these files can be opened in Excel. ( Well Excel 2000 anyway ).
Hope this helps,
Gavin...
>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?
>
>Thanks in advance for your help.
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