Import multiple excel Worksheet / workbook to a single table in Access 2010

[tunna991]

This is a situation I recently encountered. My department has over 500 excel files with multiple tabs. We want to import the data from specific tabs into one excel database. These tabs will contain the same columns. I am not good with VBA and could not find a solution after much googling.

Also each excel file has an information tab from which I want to extract data from and populate with the data I am importing. This information file lists the date and location in separate cells.

I hope I am making sense here.

 

[SkipVought]

Hi,

We want to import the data from specific tabs into one excel database.

This is an Excel VBA question that ought to be reposted in forum707.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]