Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exporting large files to Excel
Message
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00960188
Message ID:
01238525
Views:
16
>>I´m trying to export a file to excell, but only 16383 records are in the output file.
>>there are about 40000 records in total that should be exported
>
>It's limitation of COPY TO...TYPE XL? command in VFP7 and earlier. In VFP8 you can export a maximum of 65,535 rows, which is Excel 97 and later limit.

Sergey,

How can you export more than 65K rows for Excel 2007?

Thanks a lot in advance.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform