Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using cell values in SQL (MS Query)
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using cell values in SQL (MS Query)
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using cell values in SQL (MS Query)
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 - |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using cell values in SQL (MS Query)
When you are editing the query using the interface (not the wizard)
use square brackets with a space in between to create parameters. These will enter the ?s in the SQL statement while the interface writes SQL for you. When you return to Excel, you'll be prompted for the parameters. You can choose ranges (cells) for the parameters and tell it whether to always look there for each parameter. Cliff Edwards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query to take values from Cells | Excel Discussion (Misc queries) | |||
Take values for Query from Sheet | Excel Discussion (Misc queries) | |||
Query linked cell values | Excel Worksheet Functions | |||
Using the values in range of cells in an SQL query | Excel Programming | |||
Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) |