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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CptCrusty1 - 27 Jul 2005 16:29 GMT

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?

Reply to this Message

Klatuu - 27 Jul 2005 18:59 GMT

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.

> 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,
[quoted text clipped - 5 lines]
> etc.
> Any ideas?

Reply to this Message