Merging Several Databases with multiple tables

Microsoft Access 2003 (full product)
May 30, 2012 at 13:19:23
Specs: Windows XP
I'm currently working with a historical society. They have much of their information in databases in the form of Access 2003 files. The problem is that these files have been duplicated, renamed, spread around a handful and different computers, and then independently updated. There are certain common tables that the majority of them have, but these tables are in 2 or 3 different forms of completeness. Furthermore, the more complete and up to date files have up to 22 tables in them, each of which is a different category. Many of these tables are input from specific forms that allow the proper information and identification numbers to be given to the various items in the various categories. What needs to be done is that all the information needs to be centralized in a single database, not spread out, because it needs to be all accessible. To compound the problem, not all the tables are in the exact same format, even though they mostly have the same fields. Is is possible to combine all the tables of the same from all these various databases together so that all the information is in one place, while in the process eliminating duplicates? I'm sorry if this is all very confusing. I also am thoroughly confused by the sorry state of these databases, not helped by the fact that I am a complete novice when it comes to Access.

Thank you in advance.

See More: Merging Several Databases with multiple tables

Report •

June 2, 2012 at 01:13:24
Do you know how to use queries and relationships?
It would probably be best to create a query which uses the similar data from the different tables.
Relationships could get rid of the repeated data - use a table which has one of each different records and link them to the tables which have many in the same field, using a 1:Many relationship.

Try to get all the data into the same computer as well. You can connect to "External Data" to connect two databases (or database to spreadsheet).

Report •
Related Solutions

Ask Question