I can't figure out this error message. Could someone please help.
I have a text file in Notepad with the following 4 fields (Cont, Code,
List, and Numb)all of which are single tab delimited, and a bunch of
rows with values. I tried to create a macro (with the TransferText
action) that would automatically import the values from those fields
into an Access table called TestingTable which i created with the
exact same field names and text types as the text file.
Unfortunately, i get the following message when i run the Macro:
Field 'Cont_Code_List_Numb' doesn't exist in destination table
'TestingTable.'
For some reason the macro error message seems to be combining my
individual text file fields (Cont, Code, List, Numb) into one combined
field 'Cont_Code_List_Numb'.
I don't get this. Please help !