Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Export to Excel
Message
From
23/04/2002 11:09:09
 
 
To
22/04/2002 13:31:51
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00647684
Message ID:
00648171
Views:
19
In addition to copying to a Foxplus or Fox2x table you can copy to TYPE CSV that will copy all records to a file that can be opened in EXCEL. Problem is that Excel 2000 still imposes a limit on the number of rows. It appears to be 65536 rows.

If you don't have more than 65536 records you may be able to copy to TYPE CSV file and directly open it in Excel. Be aware that there will be a problem using CSV file if you have character fields that contain numeric data padded left with 0. It will be interpreted by Excel as the number without the left padded zeros. Copy to DBF table opened in Excel still will have a row limit, but numeric data in character fields padded left with 0 will be preserved.

No matter how you save the file to EXCEL, different versions of Excel will truncate the file if its rows exceed the maximum number of rows that Excel can handle.

Excel 4x - 16384 rows
Excel 5x - 16384 rows
Excel 2000 - 65536 Rows

HTH
Elmer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform