| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parameters Button Greyed Out Why?
Trying to add a cell reference as a SQL Query parameter, but the
Parameters... button is disabled. If I do a web query, the button is enabled. Can we not use parameters with SQL queries? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Parameters Button Greyed Out Why?
Your query needs to have a parameter in it. Most likely your query does not
require a parameter so XL has no way to pass it a value. -- HTH... Jim Thomlinson "M Y" wrote: Trying to add a cell reference as a SQL Query parameter, but the Parameters... button is disabled. If I do a web query, the button is enabled. Can we not use parameters with SQL queries? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Parameters Button Greyed Out Why?
Is Microsoft Query the only place you can add those parameters? I haven't
been able to specify parameters for any of the OLEDB data sources, either directly or from the wizard. Is there a way to get to the Microsoft Query tool for non-ODBC data sources? "Jim Thomlinson" wrote: Your query needs to have a parameter in it. Most likely your query does not require a parameter so XL has no way to pass it a value. -- HTH... Jim Thomlinson "M Y" wrote: Trying to add a cell reference as a SQL Query parameter, but the Parameters... button is disabled. If I do a web query, the button is enabled. Can we not use parameters with SQL queries? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge button greyed out | Excel Discussion (Misc queries) | |||
| Greyed-out Share Workbook button | Excel Discussion (Misc queries) | |||
| Publish button/command greyed out | New Users to Excel | |||
| Save button will not work- greyed out? | Excel Discussion (Misc queries) | |||
| greyed out button | Excel Discussion (Misc queries) | |||
Linear Mode
