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