my goal is to write code to import a statically named file to a tabel. i've tried usign the docmd.transfer text.
is this possible? I am getting an error with the txt header not matching my pre define field names.
here's my coding:
DoCmd.TransferText acImportDelim, , "RMT_Trns_UPLOAD", strFullTxtPath & "RMT_TXNS_CURRENT.txt", True
more on the error:
if i open the .txt the the first row has YYYYMM and then data below ...this needs to import to the first field of the table.....then there is a space in the txt file to the second header Ethnic....this needs to improt tot he second field of the table.
NOTE: the field names in my table match those int he .txt.
thnaks
tuk
is this possible? I am getting an error with the txt header not matching my pre define field names.
here's my coding:
DoCmd.TransferText acImportDelim, , "RMT_Trns_UPLOAD", strFullTxtPath & "RMT_TXNS_CURRENT.txt", True
more on the error:
if i open the .txt the the first row has YYYYMM and then data below ...this needs to import to the first field of the table.....then there is a space in the txt file to the second header Ethnic....this needs to improt tot he second field of the table.
NOTE: the field names in my table match those int he .txt.
thnaks
tuk