Appending Data on Import Importing Headers as well as Data (1 Viewer)

robsmith

New member
Local time
Today, 07:52
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
 

Ranman256

Well-known member
Local time
Today, 03:52
Joined
Apr 9, 2015
Messages
4,339
you didn't say HOW you are importing. what command?
 

Gasman

Enthusiastic Amateur
Local time
Today, 07:52
Joined
Sep 21, 2011
Messages
14,050
I seem to recall there is an option to state whether there are headers or not?
 

CJ_London

Super Moderator
Staff member
Local time
Today, 07:52
Joined
Feb 19, 2013
Messages
16,553
you also don't say what you are importing from - which can make a difference if headers are not on the first row
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 03:52
Joined
Feb 19, 2002
Messages
42,981
Start again with a new import. Check the option that says the input file contains headers.
 

Users who are viewing this thread

Top Bottom