Re: Querying Mutliple Databases


> I don't think you understood what I am trying to do. I want to bring
together
> numbers from different spreadsheets into one table.

You did not say "one table" in your original message.
You should have stated more precisely what you really wanted.
In fact I think you really mean you want the results in 1 recordset rather
than a table - is that right?
And I think you want data from different Multiple Workbooks, yes?

But at this point how do you want combine the results in 1 recordset?
Are you looking for a SQL JOIN or a UNION?
I know you can do this in SQL Server using SQL
But I don't think it can be done using the Jet Provider.
At this point it is not an Excel-limitation, it is a Jet Provider limitation

See

How To Use ADO with Excel Data from Visual Basic or VBA
http://support.microsoft.com/kb/257819/EN-US/

and it seems clear that you can SELECT data from multiple worksheets within
a Workbook but _NOT_ from multiple workbooks. If you want data from multiple
worksheets within 1 Workbook then you are in luck, should be okay. From
different worksheets you are stuffed. There is no way of specifying
different Workbook sources as some sort of prefix to the ***, the Workbook
source is specified in the Connection (unlike SQL server).

Stephen Howe






.