>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement