unable to import from csv to memo field


R

ram vemuri

When I import data from a csv flat file to access, the memo datatype columns
are truncated at 255. I found a lot of information about various operations
on the data that result in trucating it, but I can't even get the data in.
The source data is in csv, and I created the table with specific columns as
"Memo" data type that I expect to have long strings (not too long, about 2k).
Any help is appreciated.
BTW, Access query performance totally rocks compared to mysql.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top