I'm a beginner. I have what is probably a basic question, but I can't find the answer.
I originally had a text file that contained a Header Record that defined all the field names for a table I was building. I allowed Access to use that first record (First Row) to assign the field names for those records when I used a text import. Now I would like to add records to that table, but the data I get does NOT have that same Header Record in it. Access seems to be requiring me to have that record in it to do an import with an Append since that's the way the table was created. So I am having to manually add a Header Record to my file to accomplish the task. Obviously, that's not satisfactory.
Is there any way once I create a table using that First Row feature I can easily import these records without a Header record?
Thanks