Import txt files into Access with columns > 255 characters

Y

Yann Lepant

Hello,

I use the code below to upload data from a flat file into an existing table
in my Access database. This process fails to insert strings over 255
characters into the targeted table columns eventhough the columns data type
are set to Memo.

This issue only occurs on import. The export process works ok. Here is the
command line I use to import the data:

DoCmd.TransferText acImportDelim, , rst("Col1").Value, "myTextFile.txt", True

Any input on how to resolve this issue will be much appreciated.

Regards,
 
J

Joe Fallon

Check your import spec on the advanced tab and check the data type.
I bet it is set to Text 255.
Change it to Memo.
 

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

Similar Threads

Import Excel with more than 255 columns 1
Truncation of memo fields using DoCmd.TransferText acImportDelim, 1
Help Importing Multiple Text Files into Different Tables 7
Saving Import Errors 0
Import Excel 2010 table into Access 2010 - not listed as range 0
Import Excel CSV file into Access 2007 2
unable to import from csv to memo field 1
CSV import error only with code 3

Top