Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Importing an Excel File
Message
De
02/10/2003 09:32:50
 
 
À
02/10/2003 00:14:23
Chris Hui
www.adv-plus.com
Kwun Tong, Hong Kong
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00834086
Message ID:
00834229
Vues:
24
>Dear all,
>
>I am a new user of the VFP 8. Hope you could give me a hand on this.
>
>I am trying to import an excel file (excel 2000) into a cursor. I typed the following
>
>IMPORT FROM "abc.xls" TYPE XL8 SHEET "Sheet1"
>
>It works fine so far. But I found that when my excel file have more than 10000 records, the above command would return an error and say "Microsoft Excel File Format is invalid". Is it a limit for the import command? Can I make it larger? 10000 is just too small....
>
>Thank you very much
>
>Regards,
>Chris

Chris, I don't seem to have that problem. I can import 10,001 rows without a problem. Are you sure there isn't something in that 10001st row that is causing it?

Alan
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform