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

RTF data from Excel 2007 to Access 2007 1
Import errors importing Text into existing table, header vs no hea 3
Importing Excel Data into MS Access Table 1
Importing Data from Spreadsheet - Efficient Design 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Importing to an existing database 2
Importing Data into Access 2003 - Data disappears 1
Copying an Excel table into an existing Access table? 1

Top