Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Export a dbf to a xls or xl5
Message
From
08/03/2005 16:54:36
 
 
To
08/03/2005 16:43:02
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00993820
Message ID:
00993822
Views:
30
VFP 7 is limited to 16 384 records for Excel file. You can use a CSV file to bypass this limitation:
COPY TO test.csv TYPE csv
Upgrading to VFP 9 will also resolve your problem.

Note that both options have another limitation: 65 535 records max.

>I have a dbf that i want to export to a excel file. I open the dbf and its contains 33372 records. when i do export to filename type xls (or xl5) only 16384 records are exported to the xls file.
>
>Is that a know problem ? And if so... are there any sollutions ? Are there any other ways to export a dbf to an excel file without losing information ?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform