Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL statement for left outer join for ranges in the same file
Hello,
I need a left outer join between 2 ranges in the same workbook (2 sheets). I created the sql statement using the MS-Query tool however it references a database (the file on my C drive) and creates a separate script file (.qdy). I have a 2 part question: 1) Can I accomplish the join where there is no concept of opening an external database? My database is the file I am in. I need the file to to be portable and self referencing as far as the database goes. 2) Along the same lines: can the qdy file be part of the xls file and be executed as a macro or in VBA? I have tried using the sql directly using sqlexecquery statement but that requires opening a database etc. and probable other References to pass syntax check for sqlopen etc. Instead of the sql, would it just be more efficient to use index/match functions to do the lookup on the target range (the left outer range) and then convert the formulas to values? Thanks, Manish |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
outer join in query | Excel Discussion (Misc queries) | |||
Require help related to Excel Query outer join problem | Excel Discussion (Misc queries) | |||
Outer join with 3 tables using MS Query | Excel Programming | |||
Outer join with 3 tables using MS Query | Excel Programming | |||
MS Query Outer join with three tables | Excel Discussion (Misc queries) |