Import into Tables

[TJVFree]

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 I’d 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.

Thank you

TCB

 

[SkipVought]

Hi,

Horrible design to name tables with data values!!!

Would be much better to Create/UPDATE one table to contain all this data.

 

[TJVFree]

The names are makeup just for examples

TCB

 

[Andrzejek]

The names are not the problem; your data structure you want to have when you are done is the problem. You are going to end up with 10 tables with the same structure, just different tables’ names – and that what is “Horrible design”

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.