Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Importing csv file to database
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01682654
Message ID:
01682658
Vues:
49
> Howdy and grand rising,
>
> I am trying to import a csv file into a database that has memo fields. When i code: append from myflie.csv to myNewDbf type csv - myNewDbf has some memo fields. apparently when i append from the csv, it does not input the cells into the memo fields on myNewDbf and therefore it skips those columns which kinda throws the data off, if that makes sense..any ideas ?

Assuming that the CSV you're importing from doesn't have multi-line fields and doesn't have fields longer than 255 characters, this simplest way might be to create a temporary cursor with the same structure as your database table but with the memo fields replaced with c(255)

Then Copy the CSV into the cursor and then APPEND from the cursor to your database table.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform