General information
Category:
Coding, syntax & commands
> 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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only