import a txt file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I CAN import a multi-field comma-delimit text file manually, but CANNOT do so
through code like this:

docmd.transfertext acImportDelim, , "tblname", "c:\filename"

The imported data turns out to be one field in the new table.

By the way, the source text file looks like:

xxxxxx;yyyyy;zzzzz
xxxxxx;yyyyy;zzzzz


Why? Any sulotion?

Thanks!

Howard
 
Uhmmm.
Those are semi-colons, not commas.

Also use an import spec and fill out the Docmd parameters completely.
 
I have the same problem while importing text file. My text fille is tab
delimited. I am working in Access Project (not Access Database). Is it true
that specification file is not exist in Access Project? Any way out?
 
Back
Top