>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
Previous
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