I'm trying to set up an Import Specification so that I can reference it in VB code to import a text file into an Access table.
My Access table has field names. My text file does not have field names.
I did the following:
File/Get External Data/Import
I clicked on text file, selected Delimited (by TAB)
I clicked Advanced
I clicked Save As and gave it a name
When I reference the name in my code, I get an error "Field 'Field1' doesn't exist in destination table 'MyTable.'
Any way around this since my Access table has field names but my text files doesn't?