Import txt files into Access with columns > 255 characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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.
 
Back
Top