SQL for ADO recordset using table joins of multiple sheets?

[neemi]

EXCEL 2007

Does anyone know what the syntax for joining multiple sheets via ADO to populate a recordset would be based on multiple sheets?

I am trying the below but it does not work.

SELECT
[Sheet1$].[column1]
,[sheet2$].[column2]
,[sheet2$].[column3]
FROM [Sheet1$]
LEFT OUTER JOIN [Sheet2$] on [Sheet1$].[Column1] = [Sheet2$].[Column1]

 

[neemi]

All sorted now.
FYI.
using multiple joins required bracketing around the joins and "LEFT JOIN" instead of "LEFT OUTER JOIN