mvandhu
12-27-2011, 08:23 AM
Hi All,
I have some clarifications on using SQl queries in VBA.
I have a workbook with 3 sheets. The first 2 are the input sheets. Based on some key columns (say 2 column values) I have perform left outer join (or any join operation) on the 2 input worksheets. I searched in many sites and all the sites/forum used OLEDB connection (used Access or specified the path where the workbook resides). So my question is- can I use SQL join query on these 2 input worksheets without using that OLEDB connection or Access DB?
If so can you specify the syntax or sample code for a join operation?
I have some clarifications on using SQl queries in VBA.
I have a workbook with 3 sheets. The first 2 are the input sheets. Based on some key columns (say 2 column values) I have perform left outer join (or any join operation) on the 2 input worksheets. I searched in many sites and all the sites/forum used OLEDB connection (used Access or specified the path where the workbook resides). So my question is- can I use SQL join query on these 2 input worksheets without using that OLEDB connection or Access DB?
If so can you specify the syntax or sample code for a join operation?