This file might be a help:
http://www.bygsoftware.com/examples/...SqlRequest.zip
It's in the "Excel with Access Databases" section on page:
http://www.bygsoftware.com/examples/examples.htm

This workbook demonstrates how to get data direct from an MS Access table,
or from an open or closed MS Excel workbook using the workbook function
SQL.REQUEST.

Recently updated to show the use of SQL.REQUEST in the same workbook.

The code is open and commented.


--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"Boris" wrote in message
...
Dear Group...

How can I retrieve some data from Sheet2 to Sheet1 with SQL specific query
?

For example I have Col1 and Col2 in Sheet1 and want to display Col3 which
is
column from sheet2 with specific condition (where, order by etc.etc.)?

How ?

Thanks

Boris