I am trying to write a SQL statement that will allow me to find multiple parameters in a table and having difficulty. I am able to set the table with "in [parameter]" and link it to a cell in excel, but I want to put multiple values in the cell with commas separating them. So in the SQL statement it looks like table.database in (1,2,3,4,5) but when I replace it with table.database in (?) it allows me to set the ? as the value of a cell in excel. The only problem is when I set the value of the cell to 1,2,3,4,5 it says it expecting something else. If I leave the cell as one digit it will pull the data for that one value. So my questions is how do I link multiple values in one cell? Thank you for any assistance in advance. I am a beginner so if the above does not make sense please let me know.
