Hi Folks,

When test.txt file (delimited separated by commas) is imported using this command

   DoCmd.TransferText acImportDelim, , "TestTable", "d:\Test.txt", False

I get a file conversion error for 1 field type - this field type is declared as a text (it mainly has numbers, but occassionally will have a letter in them). Ex.

   015948888282 - transfers ok
   B10399499293 - is flagged as "File Conversion Error" and placed into a new table.

I can do this process manually, without any problems, but can't seem to get VBA to pull the mixed content (letters and numbers) into the table.

Any suggestions?

JG