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

Please see a very similar question/answer of mine here stackoverflow.com/a/40637025/2446254 — Cody Geisler
– Cody Geisler, Commented Jan 30, 2017 at 15:46
yee but I didn't find there the answer. I just have no possibility to choose the parameter for "?" ;( — Uekonometria Uekonometria
– Uekonometria Uekonometria, Commented Jan 31, 2017 at 8:25

Cody Geisler · Accepted Answer · 2017-01-31 14:41:43Z

0

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.

answered Jan 31, 2017 at 14:41

Cody Geisler

8,6272 gold badges41 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

yeee i didn't get the third window ya showed :( but nevermind, i coded it in VBA