Pulling from a .txt file

Hello,

I'm looking for some help.

Working in Access, i'm trying to pull data from a .txt file to populate cells in a table on another file.

This is the command i'm using:

DoCmd.TransferText acImportDelim, "testnew", "Tablenew", "C:\Users\fitst\Documents\Drive(D)\Access\Intransit GL\Period 05\testnew.txt", True

I'm getting an error because this command seems to only work while pulling from an excel file.

How would i get it to work to pull from a .txt file?

Any help would be appreciated!

Thanks,

Paul