View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rael_lucid
 
Posts: n/a
Default 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?