There are a couple of ways to accomplish what I think you want to do.
First, with Access you can link to a text file and treat it the same as any other table. Of course, that works if the text file is in the proper format.
The other method is to use the TransferText method of the DoCmd Object:
Here is the syntax:
DoCmd.TransferText acImportFixed, , "tblTemp", "C:\MyFiles\DataFile.txt"
where "tblTemp" is the name of the Access table into which you want to import the file, and "C:\MyFiles\DataFile.txt" is the name of the text file.
You can create an Import Specification to control how the text file is imported. Search Access Help for TransferText to learn more about the specifics.
HTH
George
