Using cell values in SQL (MS Query)
Thanks. A couple of issues:
1) Can't do [ ... WHERE col IN (?)] Only allows single values.
2) Can't have a parameter in a query that can't be displayed
graphically.
Are these for real?
On Feb 21, 8:51*am, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
Add a prompt to your query so that it becomes parameterized.
select * from table where id = ?
Now exit the query and return to XL. If you select Data - Import External
Data - Parameters you will be able to assign the parameter to a cell.
--
HTH...
Jim Thomlinson
"Arshavir Grigorian" wrote:
Hi,
Is there an easy way to use cell (or range) values in an MS Query SQL
- e.g. [select * from table where id = Cell("E4")]. TIA.- Hide quoted text -
- Show quoted text -
|