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.
January 10, 2025
Access Top Contributors:
How do I import multiple Excel files with multiple tabs into an Access database?
Report abuse
Thank you.
Reported content has been submitted
Something here should help...
Microsoft MVP (Access 2010-2015)
https://www.access-diva.com/tips.html
Report abuse
Thank you.
Reported content has been submitted
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.
Report abuse
Thank you.
Reported content has been submitted
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: