Parameter/Criteria option not available for External Data Query
 

Hi,

I have written a query in Excel which extracts data from an MS SQL database
and would like to add a date retriction as a parameter so that not all rows
are returned. Unfortunately though, the parameter option is greyed out. I am
even unable to add the parameter manually to the SQL query. Does this have
something to do with the complexity of the query?

Parameter/Criteria option not available for External Data Query
 

Display the criteria pane View--Criteria

Select a field and in the Value field type a parameter name in square
brackets like [parm1].

You can then select View-- parameters

For help look ínto the MS Query help for "parameter" and then "create
a new query" and then "create a parameter query".

When you leave MS Query on the next dialogue you can select
"Paremeters" and define "how a parameter value is obtained" which lets
you e.g. select a value from a cell on your worksheet.

Hans

Parameter/Criteria option not available for External Data Quer
 

thanks Hans, but unfortnately the Criteria option is not available

"flummi" wrote:

Display the criteria pane View--Criteria

Select a field and in the Value field type a parameter name in square
brackets like [parm1].

You can then select View-- parameters

For help look Ã*nto the MS Query help for "parameter" and then "create
a new query" and then "create a parameter query".

When you leave MS Query on the next dialogue you can select
"Paremeters" and define "how a parameter value is obtained" which lets
you e.g. select a value from a cell on your worksheet.

Hans