how to merge two (or more) databases on different computers

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

Guest

I have three pieces of information about my company's contacts on three
different computers but with the same field names and now i want to merge
them all so that I can have all of the data from those three files in one
single access file.

And i use microsoft office 2007.

Can anyone please help me to the quickest.

It's very urgent

Thanks

VaibhavJ
 
Hi VaibhavJ,

Make copies of all three databases on one computer.

Then create linked tables in one of the databases, connected to the
tables in the other two.

Next, use append or update queries to move data from the linked tables
to the "real" table(s).

Finally, delete the linked tables.
 
Thank you Mr. Nurick for your response. But there is one more problem. i am
relatively new to access and dont know about the "append or update queries".
If you could please explain it more in detail about how to use them.

Thanks
 
The general idea is that if there are records in the linked tables
that don't exist in the destination table, you use an append query to
append these records to the table.

If records in the destination table need to be updated to match the
corresponding records in one of the linked tables, you use an update
query.

See the Help topics
Create an Append Query (MDB)
Create an Update Query (MDB)

Be sure to work only with copies of the databases. That way you can
experiment with the queries until you get the hang of them without
risk to your data.
 
Back
Top