Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing an Excel File
Message
From
02/10/2003 05:39:30
 
 
To
02/10/2003 04:21:47
Chris Hui
www.adv-plus.com
Kwun Tong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00834086
Message ID:
00834151
Views:
20
>Hi Jos,
>
>Hm... I tried to import 10001 and 65xxx records. Both encountered the same error.
>
>That's alright. Thanks for your reply anyhow. :)
>
>So, do you know if there is any easy way to import an CSV file to a VFP cursor, given that I didn't know how many column I will have in the CSV file at design time?
>(so I cannot use APPEND FROM. Actually, APPEND FROM is encountering the same 10000 records error that IMPORT has)
>
>
>Regards,
>Chris Hui

Hi Chris, personally I would use IMPORT FROM which will allocate columns as necessary. I would then parse the columns as required. But I think that there might be something else going on becuase I have not heard of a 10,000 record limit on either of these commands. If you like you can zip the file and send it to me and I can try to see if I get the same thing.
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