Querying Excel-Sheets with ADO using Inner Join
 

Hi!

I use ADO to query an Excel-Worksheet. I can do this
quite well for ONE sheet.

Now I need to query two sheets using an Inner Join in the
SQL statement.

I seem to miss something creating my query since i get an
error message stating that something is wrong with my
join expression...

Here is the statement:

SELECT VP FROM `Data1$` INNER JOIN `Data2$` ON `Data1
$VP`=`Data2$VP`

Any idea anyone? thx in advance,

Karla

Querying Excel-Sheets with ADO using Inner Join
 

"Karla" wrote ...

i get an
error message stating that something is wrong with my
join expression...

Here is the statement:

SELECT VP FROM `Data1$` INNER JOIN `Data2$` ON `Data1
$VP`=`Data2$VP`

Try:

SELECT T1.VP
FROM [Data1$] T1
INNER JOIN [Data2$] T2
ON T1.VP = T2.VP
;

Jamie.

--