import a txt file

[Howard]

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

 

[Roger Carlson]

Try this:
DoCmd.TransferText acImportDelim, "", "tblname", "c:\filename.txt"

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Philibin]

Are you using any import specifications?

-Bill

 

[Joe Fallon]

Uhmmm.
Those are semi-colons, not commas.

Also use an import spec and fill out the Docmd parameters completely.

 

[Agus Budianto]

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?