Two Identical Databases - Need to move from one to the other

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have two identical databases (Access 2000) and need to moved data from one
database to the other creating one matser/complete copy.

All data from one of the databases needs to be copied across.

I have been asked to do this froma friend so at this point I don't know how
many tables there are.

Is there an easy way to do this; perhaps some utility or tool?

My thoughts where that I would need a select statement. What is the
best/easiest way to do this?

I am not an access user so any help would be appreciated.


Many Thanks

Paul
 
Do you merely have to combine 2 tables into one table (realizing that you'll
have to do this multiple times for each table set)?

If so, the first thing I'd do is import each table that needs to be combined
into one of the databases (doesn't matter which one, as long as you
understand that one of the databases is old and out of date).

To do this click Tables, click new, select import table. navigate to the
database that holds the table you want to import and select each table to be
imported. click import

once you do this you'll see that your db contains both tables from each db.

next you need to ensure that you don't have duplicate records in the table
that you are going to import. If you are certain that the tables have unique
records, the next step is simple...

click queries, click new, click design view. select one of the tables that
you just imported and insert EVERY field that you want to add to the existing
table. (one by one, add ALL of the fields). next click query, select append
query, select the table you'd like to append the records to. ensure that an
"import to" field is listed for each of the fields. if they're missing, pick
the correct field from the drop down box.

once you've finished setting up the query, click the ! to run the query.
You'll probably be warned that you are about to append ###records. click ok
and you're done.

you'll need to set up and run a query for each of the tables that need to be
combined.

that's it...
 
Before you start, make backups of each database.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top