Hi All,

This might seem like a redundant question but I checked a lot of answers but nothing seem to work.
I created a data connection using MS Query trying to query in SQL Server. It is not a complicated query that I am using. The query is trying to select 5 columns from a table. In the where clause I have a parameter which needs to select multiple text values from one/multiple cell.

So consider this as the query:
select a1, a2, a3, a4, a5 from table1
where a6 in (0,1)
and a7 in ([param1])

The values I have in excel are something like below.
Param1
abc cde
efg ghi

and so on.

The param1 is dynamic in both number of values and the value itself.


I tried using the parameter value as Equals and well as Is One Of.
When I try using one column it works fine but If I concatenate the column to use values like "abc cde,efg ghi" it doesnt work. Ofcourse it does not allow me to select a range of columns.

Thanks in Advance for any help.


Regards,
Lisa