Importing data from Excel into an existing Access table?

  • Thread starter Thread starter cwilson
  • Start date Start date
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?
 
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
 
Back
Top