>Need more detail, you've got 2 excel tables but where are you trying to link them and how.
>With-in excel ?
Yes, from two separate excel files <<File1.xls>>; <<File2.xls>>
>Using SQL throught some odbc driver ?
Yes, through ODBC;DSN=Excel files;DBQ=Path of the active workbook
>Using recordsets in VB
If it is possible, I would not like to use recordsets (just one SQL query)
>Are both table in the same excel file ?
No, they aren't.
Sorry not to be able clearly explaining my problem. I would just like to get maximum data from two different excel files with one query, as I showed previously.
Thank in advance for your help: