Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy old Data from web query while keeping previous days data | Excel Worksheet Functions | |||
ranking query | Excel Discussion (Misc queries) | |||
Formula Help | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
1-variable Data Table dependent on MS Query fails to update correctly | Excel Discussion (Misc queries) |