Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Export to Excel
Message
From
01/03/2000 00:16:23
Gavin Reid
L & M Marketing Pty Ltd
Frenchs Forest, Australia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00339517
Message ID:
00339622
Views:
14
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
Map
View

Click here to load this message in the networking platform