I need to create a spreadsheet that allows a user to input a column of data that will then be used, one value at a time, as a parameter in an SQL query. For instance, my query would be something like :
SELECT A, B, D, K, R
FROM TABLE1, TABLE2, TABLE3
WHERE A= D AND K= R AND (B=?)
so that the values from the column of data are used in the comparison to B.
Am I making any sense? If so, is there a way to do this? Much obliged at any help you could provide.
Bookmarks