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 you...
