Can I use ado SQL within Excel 2003 VBA to reference worksheets (tables) in two different workbooks in the same query?
I am very used to using the JET DB engine in VBA with ADODB to query worksheets using SQL in Excel 2003. However, the query always referenced sheets in one workbook at a time. Is it possible to open two connections to two different workbooks and perform a join between two sheets in the different workbooks? If so, how would I qualify the reference in the SQL query?