Import Excel File into EXISTING Access Table

[Denise]

I want to take an Excel spreadsheet that has NO Column Headers and import it
into an existing table. When I try to create an import, and choose existing
table, it automatically assumes that I have column headers, but I don't. How
do I get around this?

 

[Jeff Boyce]

?Could you just add column headers in the Excel spreadsheet?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Ken Snell [MVP]]

If you use the "Has Headers" argument as False for the import, ACCESS will
substitute column names of F1, F2, F3, etc. So the way to do this is to
import into a new table that doesn't exist, let ACCESS create the table with
the F1, etc. field names, then use an append query to copy the data from
that table to the existing table.