Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing an Excel File
Message
From
02/10/2003 09:32:50
 
 
To
02/10/2003 00:14:23
Chris Hui
www.adv-plus.com
Kwun Tong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00834086
Message ID:
00834229
Views:
23
>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
Map
View

Click here to load this message in the networking platform