Cmd Transfer text problem

[T J]

I had an import specification thaat worked fine -then the data source comma
delimited text file was changed and i revised the specification.
Now when i run the code the import doesn't work correctly - but the new
specification does import correctly if i run it in a macro or with the
import wizard...
what could be causing the code not to import correctly??

DoCmd.TransferText acImportFixed, "xxx Import SpecificationZ", "TblONE",
"C:\TEST\TEST.txt", False, ""

the original import spec was built on a different PC -WinXP - i'm on a Win2K
now - the program is Access2K
appreciate any advice on troubleshooting why the new specification isn't
working in VBA but works in macro and with import wizard

 

[Mark via AccessMonster.com]

You said "...then the data source comma delimited text file was changed..."
and your code starts with:

DoCmd.TransferText acImportFixed,

If your data source was fixed-width and is now comma-delimited, then your
code should start with:

DoCmd.TransferText acImportDelimited,