double nine posted:

out of curiosity, is there a way to have an excel sql query refer to the content of a sheet?

for example, i have the following query:

code:

select clientid, tarifyear, this, that, and_the_other 
from database1.subdb2 t1
where t1.clientid = 123456789

and would like to have the query be dynamic so that the where statement becomes t1.clientid = table1.cellC3 or something to that effect

is this possible