Importing different worksheets from multiple Excel files

[h20vrrq]

We have approx 200 Excel Workbooks with data that needs importing into
Access. Unfortunatly the Workbooks have varying numbers of worksheets and
all need to be imported.

In all Workbooks there will be one Base worksheet, one RP(1) worksheet and
one CP(1) worksheet, but there could be as many as 30 RP & CP worksheets.
Some Workbooks may only have the one of each but many others will have a lot
more. A typical example would be one Base, 4 RP (as RP(1), RP(2), RP(3),
RP(4)) and 2 CP (as CP(1), CP(2)).

To complicate things further, in each type of spreadsheet I only need to
import a given range of cells and this range is different depending on the
type of worksheet.

How would I go about importing a different specific range of cells, from a
varying number of differnt worksheets for multiple Excel Workbooks?

Any help is much appreciated.

 

[pietlinden]

We have approx 200 Excel Workbooks with data that needs importing into
Access.  Unfortunatly the Workbooks have varying numbers of worksheets and
all need to be imported.

In all Workbooks there will be one Base worksheet, one RP(1) worksheet and
one CP(1) worksheet, but there could be as many as 30 RP & CP worksheets. 
Some Workbooks may only have the one of each but many others will have a lot
more.  A typical example would be one Base, 4 RP (as RP(1), RP(2), RP(3),
RP(4)) and 2 CP (as CP(1), CP(2)).

To complicate things further, in each type of spreadsheet I only need to
import a given range of cells and this range is different depending on the
type of worksheet.

How would I go about importing a different specific range of cells, from a
varying number of differnt worksheets for multiple Excel Workbooks?

Any help is much appreciated.

I would start here...
http://www.mvps.org/access/general/gen0008.htm

and then write different routines to import the various chunks you
want.