I'm not sure if I understand you correctly. But if you are indeed trying to do this in Access (and not VB), then here's something I've done to import a text file into a table.
DoCmd.TransferText acImportFixed, "CommissionSpec", "tblImport", "C:\data\commission.txt", False
This is to import a...