Importing XLS worksheets, over and over.... check this out...

[CptCrusty1]

I have a large number of folders, each with different names, that need to be
gone through, and the xls workbooks imported. Each folder has 3 workbooks,
each with a different name, and the workbooks all have 10-15 worksheets. I'm
trying to append the data consequitivley... IE...

FOLDER1\ABC.xls-worksheet 1 APPENDED TO Access table with information from
FOLDER2\ABC.xls\worksheet 1.
etc.
Any ideas?

 

[Klatuu]

I would suggest you use the FileSearch object which will return an array of
all the files you want to include. Then, link to each Excel worksheet and
append the data to the table you want the data in.