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:
00815393
Views:
9
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?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform