General information
Category:
Coding, syntax & commands
Title:
Error: Microsoft Excel file format is invalid
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only