Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exporting large files to Excel
Message
From
10/11/2004 15:26:03
 
 
To
10/11/2004 15:14:15
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:
00960198
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

David,

From the VFP8 help file, "Note Though you can export a maximum of 65,535 rows, which includes one row reserved for the field header, versions of Excel earlier than 8.0 (Excel 97) display only the first 16,384 rows and cannot import files containing more than 32,767 rows."

Also, VFP7 doesn't support copying to an Excel 8 or newer file.

A possible work around is to export the file as type Foxplus which Excel can import directly.

HTHs,
Jim
Previous
Reply
Map
View

Click here to load this message in the networking platform