TransferText fails with err# 2391

[HarryStamper]

I have a daily rtn which imports a csv file. I am able to import the table manually, however when I run my docmd.TransferText statement, it fails on err#2391.
The field that 2391 displays is a wacky name...

I use the table struct from the manual import and I still get the error message. So, i am puzzled. Is there a limit to the length of the name field in access tables...(255 I think).

 

[rjoubert]

Can you post the entire Docmd.TransferText statement? I looked up error 2391, and it normally occurs when you don't have a field in your destination table that it expects. You may want to check your import specification and verify that the fields it expects to find in your table are actually in your table.