Appending Data on Import Importing Headers as well as Data

robsmith

New member
Local time
Today, 18:34
Joined
Feb 17, 2020
Messages
26
Hi,

I have created a saved import using the "Append a copy of the records to the table..." option but it is importing the headers from the source file resulting in the header row appearing as a record in the table.

Is there a way to avoid this? I am using Access 2016.

Thanks
 
you didn't say HOW you are importing. what command?
 
I seem to recall there is an option to state whether there are headers or not?
 
you also don't say what you are importing from - which can make a difference if headers are not on the first row
 

Users who are viewing this thread

Back
Top Bottom