Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Union or Join Sheets | Excel Discussion (Misc queries) | |||
i want to join values of sheets together | Excel Discussion (Misc queries) | |||
How do I join two excel sheets? | Excel Discussion (Misc queries) | |||
To join some sheets of several files in one file | Excel Programming | |||
join more workbooks in one and print sheets | Excel Programming |