How do I import multiple Excel files with multiple tabs into an Access database?

Question

I have an Access Database where I have 5 empty tables that I constantly append data to.  When I append the data initially the tables are empty.  Most of the excel files I am importing have multiple tabs on them.  I would like to find a way of importing specific tabs that I choose or if this is not an option all the tabs into a table that I choose.  I am not familiar with building macros in access databases.

Answer 1

I will check into this web site.  thanks

Answer 2

Something here should help...

http://www.accessmvp.com/KDSnell/EXCEL_Import.htm