Sorry Stanl, this is where my VB experience is lacking. From my point of view they illustrate how to reference a further sheet with the SQL code.

I probably wrongly assumed I could extend this to using INNER JOINS.

[VBA]stSQL = "INSERT INTO [Blad1$] IN 'E:\Arbetsmaterial\ALADO.xls' 'Excel 8.0;'" & _
"SELECT * FROM [Sheet1$A1:A2]"
[/VBA]

This statement reference 2 workbooks, the one from the connection ([Sheet1$A1:A2]) and then the other (ALADO.xls)

but perhaps am missing something?