Excel Microsoft Query Multiple Values Parameters, Bad Parameter type

Asked Oct 18 '16 at 16:19

Active Oct 18 '16 at 16:19

Viewed 1,065 times

I'm using office 365. In excel I import data from Microsoft Query.

My problem is that I want to have multiple values in parameter (range) (like a IN condition), I'm only able to get the parameter from cell for only a single value.

Sample Query:

SELECT * FROM F4211 WHERE SDLNTY = ? AND SDCO IN ?

In the above query the parameter selection from cell works fine for SDLNTY, since its a single value. But for SDCO can have a multiple values, but it does not work.

Error: