Re: Getting Data from separate excel sheets and join tables

That's it! Sorry for the quite long message, but I'm stuck on this for a
while now, and I don't find much information on combining ADO, VBA and
Excel.

I don't know either but I think your request basically amounts to whether
Jet Engine 4.0 can do that - because at the end of the day, "something" has
to interpret the SQL and do the work of the JOIN. It is not ADO that does
this - ADO just provides the results.

There are articles here

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

How To Transfer Data from ADO Data Source to Excel with ADO
http://support.microsoft.com/kb/295646/EN-US/

Methods for transferring data to Excel from Visual Basic (ADO is mentioned
as a solution)
http://support.microsoft.com/kb/247412/EN-US/

ExcelADO demonstrates how to use ADO to read and write data in Excel
workbooks
http://support.microsoft.com/kb/278973/EN-US/

and somehow I get the faint impression that JOINs are not supported (as
absolutely nothing is mentioned)
To do that, you would have to be able to open multiple Workbooks and/or
Sheets and I have never seen any documentaiton that says Jet can do this.

An option is 2 Connections, 2 Recordsets that are ORDERed the same way and
do a home-brew merge JOIN.
That is 1-pass over both recordsets

Stephen Howe


.