dynamic condition in query EOL odbc excel

Question

I want to load a table data from SQL data bases by Excel ODBC, but the condition "where" i wanted to be dynamic - depended on excel spread cell "A1".

I made somethin like this: a picture link

select * from tabel where id = ?

But this doesn't work and i donno how to define "?" as A1 Cell

Answer 1

Say you have the following query that works:

If you add a WHERE CLAUSE like so:

Then press OK it should prompt you to refresh your query.

At that point you should get the following dialog, which you can use to set your parameter.