Q:

How to merge many MDBs?

I have many MDBs files with the same structure and two tables each.
Is there any way how to merge this bases in huge one?
I try to use special utilit "Simple MDB Merge", but it doesn't see mdb files on my computer...

A:

You can open up one of the MDBs, and import tables into it from all the other MDBs. If there are really a lot of MDBs and it would be impractical to do it by hand, you can write some VBA code to open each MDB in turn and copy over the tables into your destination MDB. Look up the Access and DAO references for working with databases and tables.

