Parameters Button Greyed Out Why?

G

Guest

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?
 
G

Guest

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.
 
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 data query parameter issue 6
Excel 2007 data query parameter issue 1
Dynamic Parameters in Excel Cubes 2
Parameters are not allowed in queries that can't be displayed grap 1
Running speed of Micrsoft Query with Multiple parameters 1
Excel not saving query parameters 1
Parameter query question 4
Passing several parameters to OnAction property. 1

Top