Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error: Microsoft Excel file format is invalid
Message
From
21/06/1999 02:39:38
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Error: Microsoft Excel file format is invalid
Miscellaneous
Thread ID:
00231990
Message ID:
00231990
Views:
34
I created a 6 meg Excel file from a comma-delimited file - exported from inferior software - in order to perform data scrutiny. There are 762 fields in this Excel spreadsheet, far exceeding FoxPro's 255 field limit: hence the use of Excel instead of FoxPro. Created a table with 4 character fields and then, in the command window:
APPEND FROM all-cath.xls ;
FIELDS a,b,c,d ;
TYPE xl8
FoxPro chugs a bit, then returns the error in the title.

If I trim the Excel data to 2000 records, or 1000 records, or 100 records, I get the same error, but if it is taken down to 22 records, it imports fine. Glancing over the data itse;lf shows nothing weird... any ideas?
Thank you...
Robin
Next
Reply
Map
View

Click here to load this message in the networking platform