Home

Imported mdb tables not opened in the same Sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1183975%22%20slang%3D%22en-US%22%3EImported%20mdb%20tables%20not%20opened%20in%20the%20same%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1183975%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20and%20thanks%20for%20this%20forum.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20import%20table%20from%20multiple%20mdb%20files%20and%20append%20it%20into%20one%20excel%20sheet.%20Table%20has%20the%20same%20structure%20(names%20and%20number%20of%20columns%20in%20every%20table%20of%20every%20mdb).%20MDBs%20are%20in%20the%20same%20directory%20and%20all%20have%20the%20same%20structure.%26nbsp%3B%3C%2FP%3E%3CP%3EA%20macro%20I%20am%20trying%20to%20create%20opening%20tables%20in%20a%20new%20sheets%2C%20instead%20of%20first%20blank%20cell%20in%20target%20sheet.%20And%20I%20don't%20know%20how%20to%20loop%20it%20through%20the%20multiple%20MDBs.%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20help.%26nbsp%3B%3C%2FP%3E%3CP%3EJozef%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1183975%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
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. 

Jozef

Related Conversations
Filter complex table to simple table
Sam2009 in Excel on
1 Replies
Excel Table Size in Macro
WayneEK in Excel on
6 Replies
Taking values from certain rows based on data input
Drakerla in Excel on
5 Replies
Pivot tables connected
GbiKripka28 in Excel on
5 Replies
Problem with Pivot tables
GbiKripka28 in Excel on
6 Replies