Excel:使用单元格值作为 SQL 查询的参数 [英] Excel: Use a cell value as a parameter for a SQL query

问题描述

我使用 MS Excel 通过 ODBC 从 MySQL 数据库获取数据.
我使用 SQL 查询成功获取了数据.但现在我希望对该查询进行参数化.
所以我想知道是否可以使用单元格值(电子表格单元格)作为此类查询的参数.
例如，对于这个查询:

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

我想从电子表格中的单元格 D4 中获取 id 值.

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?

谢谢.

推荐答案

我遇到了和你一样的问题，Noboby能理解我，但我是这样解决的.

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])

您需要在其他工作表中插入一个参数，SQL 会将该信息视为数据库，然后您可以选择信息并将它们比较为您喜欢的参数.

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.

这篇关于Excel:使用单元格值作为 SQL 查询的参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！