Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COPY TO / EXPORT TO limit for XLS / XL5
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00815376
Message ID:
00815402
Views:
9
Thanks to you all.

>Hi Colin,
>
>The limit comes from the earlier versions of Excel. In VFP8 you can export a maximum of 65,535 rows.
>
>>Hi,
>>
>>I'm creating cursors of data which I am then putting in an Excel file using COPY TO (also tried EXPORT TO). Looking over the data, I notice that, for example, the cursor has 74,000+ records but the excel file only contains 16,713. Is VFP stopping at this many records because v2 (TYPE XLS) and v5 (TYPE XL5) of Excel had this limit?
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Previous
Reply
Map
View

Click here to load this message in the networking platform