Import Multiple Tables From Access

Greetings,

I would like to import multiple tables (simultaneously) from an Access database. I currently use Windows 2003, and I apologize if this questions has already been addressed in another post.

Any help would be greatly appreciated!

I have little code knowledge, by the way.

Regards,

Tommy

Hi,

This link could be helpful :

http://www.ozgrid.com/forum/showthread.php?t=30127

Hi Naras,

The linked information relates to table transfer from Access to Access, thus a code for Access is suggested. How do you modify the code using Excel to import several Tables from Access?

Any help or direction would be greatly appreciated!

Tommy