Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing an Excel File
Message
From
02/10/2003 01:40:51
 
 
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:
00834096
Views:
32
>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

Hi Chris

In VFP8 you can export up to 65,535 rows. How many columns are there as well - iow how many cells in total and total byte size?
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform