Add a prompt to your query so that it becomes parameterized.

select * from table where id = ?

Now exit the query and return to XL. If you select Data - Import External
Data - Parameters you will be able to assign the parameter to a cell.
--
HTH...

Jim Thomlinson


"Arshavir Grigorian" wrote:

Hi,

Is there an easy way to use cell (or range) values in an MS Query SQL
- e.g. [select * from table where id = Cell("E4")]. TIA.