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

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.

Gina Whipp
Microsoft MVP (Access 2010-2015)
https://www.access-diva.com/tips.html

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I will check into this web site.  thanks

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated August 12, 2024 Views 432 Applies to: