Cmd Transfer text problem

  • Thread starter Thread starter T J
  • Start date Start date
T

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
 
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,
 
Back
Top