Hello,

Could someone help me with a VBA script that will do the following?
Import 12 MS excel workbooks
Each workbook is named 1, 2, 3 etc.
In each workbook there are 10 tabs with each tab having a different name Mary, Peter, Jane etc. but the same as the other workbooks.

What Id like to do is import each workbook with the tabs creating 10 tables

Go out for folder C:\Testfolder
Import worksheet 1 into access database
Make each tab a table
Go out for folder C:\Testfolder
Import worksheet 2 into access database table Mary, Peter, Jane etc.