Hi..
Please take a look at the TransferText command in Access help..
DoCmd.TransferText [transfertype][, specificationname], tablename, filename[, hasfieldnames][, HTMLtablename][, codepage]
not all parameters need to be used.. as is
DoCmd.TransferText acImportDelim,MySpec,"MyTable","C:\MyData.txt"
MySpec is created by first going to Access and doing a manual import, on the advance tab of the import, you will have the opportunity to save the import as a specification that can be used in the automatic import you are creating