I used the command below to transfer the .txt to my existing file called "gbilsts", it do not work,
and promp msg "field f1 doesn't exist in the destination table "gbilsts"" , but when i used the the import wizard in the Ms access
it work fine, the problem is how can i used command code to transfer the things to my existing table.
DoCmd.TransferText _
transfertype:=acImportDelim, _
tablename:="gbilsts", _
filename:="E:\JTI\gbilsts.txt"

i'm appreciated if you can help me.