Information générale
Catégorie:
Codage, syntaxe et commandes
> 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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement