Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Importing an Excel File
Message
De
02/10/2003 05:39:30
 
 
À
02/10/2003 04:21:47
Chris Hui
www.adv-plus.com
Kwun Tong, Hong Kong
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00834086
Message ID:
00834151
Vues:
19
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform