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.

Sounds like a file problem,



Why don't you try performing the task in a macro, then if it works convert it to code.