transfertext error 3440

[wsuh]

I'm having problems with the transfertext method in Access97. Although I can import the tab delimited files using the get external data/import function from the drop down menu, I can't execute the following:

file_name = "C:\Won\Apps\losaht.txt"
table_name = "tblAHT"

DoCmd.TransferText acImportDelim, "", table_name, file_name, False, ""

I receive the following error message:

error 3440:An attempt was made to import or link an empty text file.

The text file is not empty. any ideas? Thanks.

 

[Aivars]

Hi!
Create Import Specification for importing of delimited text type data.
Aivars