Combine Databases

[brian7268]

Does anyone know a tool/way to combine/compile databases? I have over 2,000 databases with the same table structure and my end goal is to have 1 database with all the data.

Thanks!

 

[eirman]

You could start with your largest table and run a series of append queries ...
http://office.microsoft.com/en-us/access-help/adding-rows-by-using-an-append-query-HA001186063.aspx
This should make one big table, leaving your originals intact.


Read this for info on how to import froms from one db to another
http://office.microsoft.com/en-001/...t-to-another-access-database-HA001227659.aspx

 

[eirman]

There is an automated method suggested here .....
http://www.access-programmers.co.uk/forums/showthread.php?t=138795

 

[Mihail]

Be aware ! I think that is not as simple as seems to be.
This 2000 tables should have something that make the difference between each other; maybe Dates, maybe Names... something must be.
So, in order to maintain the referential integrity, you need (at least) 2 tables.

Post 2-3 "DBs". Keep only few records in each table (I've understand that each "DB" consist in a single table). Replace sensitive information if necessary. Use Access 2003 version.