We Talk Coding

How do I merge two microsoft access databases?

I have two access databases that have exactly the same structure and layout, but different information. I'd like to merge them into one database. What is the easiest way? I'd be most grateful to know.

Public Comments

1. Open the database you want your data to be in, then use Import (from the file menu) to import the data from the other database....
2. 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.
3. The easiest way? - extract sql datamodel and sql - uninstall microsoft access - install oracle or sybase database - upload datamodel and sql If you must use Access try using a DB reverse engineering tool like Erwin.