ExcelBanter - Query SQL server db with cell value parameter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Query SQL server db with cell value parameter (https://www.excelbanter.com/excel-discussion-misc-queries/254012-query-sql-server-db-cell-value-parameter.html)

5GenTexan

Query SQL server db with cell value parameter

I want to supply criteria value using a cell on the spreadsheet to contain a
date.

Can't seem to figure out how to do this. On the Connections - Properties -
Definition dialog, "Parameters" is grayed out.

All times are GMT +1. The time now is 03:03 AM.