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:
01238560
Views:
12
>>>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.

Yes, up to 1 million rows.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform