I wish to add and link multiple tables using Query in Excel 2003. These
tables are on different Excel workbooks.

In the Query window, when I click on the Add Tables button, only the tables
from the workbook I selected on the Select Workbook form will show up.

When I go to Data, New Database Query, and double-click on <New Database, I
may add several workbooks as data sources. Even so, my new sources won't
appear on the Add Tables listing.

I think I read somewhere in the Help that all workbooks should be located in
the same folder, but this doesn't make any difference. And I don't think I
can designate a folder as data source (or can I ?).

The only way I can succeed so far is by copying and moving all required
worksheets into one master workbook. This is not very practical.

Any suggestions ?