They are limitations of that approach. If you need more flexibility you
could use ADO directly.

Tim


"Arshavir Grigorian" wrote in message
...
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 -