Imported mdb tables not opened in the same Sheet

Occasional Visitor

Hi and thanks for this forum. 

I would like to import table from multiple mdb files and append it into one excel sheet. Table has the same structure (names and number of columns in every table of every mdb). MDBs are in the same directory and all have the same structure. 

A macro I am trying to create opening tables in a new sheets, instead of first blank cell in target sheet. And I don't know how to loop it through the multiple MDBs. 

Thanks for any help. 


0 Replies