M
mpsamuels01
I have about 50 excel workbooks and in the past I used the file dialog
box to import each workbook as its own table but that is very time
comsuming. I was wondering is there anyway to import multiple workbooks
that have the same definitions into thier own table as long as I leave
the name as sheet1 sheet2 .... The fields in the table are exactly
identical just not the data and I want to import each workbook that has
1 sheet into access into its own table or sheet.
box to import each workbook as its own table but that is very time
comsuming. I was wondering is there anyway to import multiple workbooks
that have the same definitions into thier own table as long as I leave
the name as sheet1 sheet2 .... The fields in the table are exactly
identical just not the data and I want to import each workbook that has
1 sheet into access into its own table or sheet.