Excel: Use a cell value as a parameter for a SQL query

excel, odbc

Solution

I had the same problem as you, Noboby can understand me, But I solved it in this way.

SELECT NAME, TELEFONE, DATA
FROM   [sheet1$a1:q633]
WHERE  NAME IN (SELECT * FROM  [sheet2$a1:a2])

you need insert a parameter in other sheet, the SQL will consider that information like as database, then you can select the information and compare them into parameter you like.

Problem

I'm using MS Excel to get data from a MySQL database through ODBC. I successfully get data using an SQL query. But now I want that query to be parameterized. So I wonder If it is possible to use a cell value (a spreadsheet cell) as a parameter for such a query. For example, for this query: ``` select name from user where id=1 ``` I'd like to get the id value from, say, cell D4 in the spreadsheet. Is that the proper approach to parameterize a query? and how can I do it? Thanks.

Original source