We Talk Coding

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

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?

Public Comments

1. Yes. Just create 2 databases (or Excel spreadsheets), enter the information, then copy-and-paste from one to the other.
2. 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.
3. 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/