Imbedded SQL query with a "list" for a parameter

[Big Freak CC]

I am trying to write a SQL query in Excel which needs two inputs taken in as parameters. One is just a date, which is easy and works. The second requires a list of names that will change every day.

So ordinarily, the query would read

blah blah blah
where name in ('Jon','Eric','Connie','Phil'....)

But when you set up the name list as a paramter (which has to be only a single cell), I can't get it to work. No matter what I try this error comes up:

[Microsoft][ODBC SQL Server Driver]String Data, right truncation

How can I fix this.

Thanks

Jon

 

[BrianB]

Re: Imbedded SQL query with a "list" for a paramet

In the absence of another reply ..........
I am no SQL expert, but if I needed something like this I would set up the name list as a separate table and do a JOIN query with the main table. I would probably do the job in MS Access anyway, but if you set up a query in Access it writes a SQL string, which can then be copied/pasted elsewhere from View/SQL.