Importing an Excel file with multiple tabs to 1 Access table

[umair434]

Hello all!

I am extremely weak in Access/Excel so please bear with me. I have an excel file with over 50 tabs (each tab represents a worksheet with the same format as others). I want to import this file into 1 Access table!!

I would really appreciate if someone can please guide me through this.

Thank you for your time. You guys are amazing, and make life easy for millions!

Umair

 

[GinaWhipp]

Have a look at...

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

...there are a couple of different ones that should get you what you want.

 

[umair434]

thanks again Gina! you came to the rescue again, thanks!

 

[GinaWhipp]

You're welcome and glad to be of service!