Originally Posted by
eelo
Having exact same problem and would like to learn of fix.
The work-arounds suggested will not work in my case, because using the defaults results in an invalid import. The import works correctly with the saved specification, but I can't use that spec programmatically via 'docmd.transfertext'.
My only other thought is that specification syntax is incorrect, but I didn't see a working example in Help. To help eliminate syntax as the culprit, can anyone confirm that they've gotten this to work with a tab-delimited text file in Access 2010, and if so, provide relevant code?