Is it possible to merge two separate databases using Microsoft Access?

Question

I am creating a database from scratch, conisting of names and contact information. I have to input 1000 contacts into Access. Is there a way to have two people input data into two separate databases and then merge the two into one when we complete the input proccess?

Answer 1

Yes. Just create 2 databases (or Excel spreadsheets), enter the information, then copy-and-paste from one to the other.

Answer 2

You could also create a database for each user, with linked tables to the data source. This way, they are both entering the information into the same database to begin with. To do this in Access, create a new database on the users machine, then go File - Get External Data - Link Tables. Browse to your main database and select it.



Click "Select All" when the list of tables pops up. Now you are linked to the original database, and you can do this for as many users as you want.



Hope this helps

Joshua B

http://www.microsoft-access-tutorial.com/

Answer 3

Open one of the databases and in the database window, up to file, import, locate the other database, click on tables tab and import but you must have exactly the same structure, field names, data types etc. However, before you do that, if they have the same table names, add perhaps a 1 after each name so that when they come into one database, you can then merge the tables together. Otherwise it will try to overwrite one table with the other.

Answer 4

Output both databases in the same format (xml, csv or whatever). Open one in notepad and copy everything into clipboard. Open other and paste the first's data onto end. Import combined file back into Access.