Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing csv file to database
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01682654
Message ID:
01682658
Views:
48
> 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
Map
View

Click here to load this message in the networking platform