Importing data from Excel into an existing Access table?

C

cwilson

I receive membership reports bi-weekly in Excel format; my database is in
Access (2007). Is there a simple way to import and possibly override
existing data in my Access Table?
 
J

Jeff Boyce

Rather than risk accidentally overwriting something, consider the following
approach:

1. import the data into a "temp"/"import" table, as is
2. use query/queries to "parse" the data into your more permanent (and
well-normalized) tables -- you can use update queries if appropriate, or
append queries if the data hasn't been added before.


Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

Append Crosstab Query to Existing Table 0
Autonumber field in Excel that behaves the same as Access 0
Help creating a search form in Access XP 0
Appending an existing table with imported Excel data 0
Import errors importing Text into existing table, header vs no hea 3
Import Excel 2010 table into Access 2010 - not listed as range 0
RTF data from Excel 2007 to Access 2007 1
Importing Data from Spreadsheet - Efficient Design 1

Top