When I run this command,
DoCmd.TransferText acImportDelim, "Mergetemp Import Specification", _
"471Merge", "c:\aaatmp\mergetemp\radC7555.tmp.txt"", False, ""
I get this error message.
"The Microsoft jet database engine could not find the object 'radc7555.tmp.txt'….."
If I rename the file and change the command so they both reference "radc7555.tmp" it works fine.
I want my VB utility to work no matter what the filename.