TransferText method
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
|