How do I import Excel file into an existing Access table?

B

BAK

I can get the import into a new table but don't have the option to save to a
current table. Thank you.
 
J

John Nurick

This option is only available if the column headings in the Excel range
exactly match the field names in the Access table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Table Security in Access 2013 1
Appending an existing table with imported Excel data 0
Import Excel 2010 table into Access 2010 - not listed as range 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
List all tables, including document structure 0
Adding data to MS Access from csv file 0
Embed the same Excel multiple times 0

Top