Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error: Microsoft Excel file format is invalid
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Error: Microsoft Excel file format is invalid
Divers
Thread ID:
00231990
Message ID:
00231990
Vues:
35
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform