ExcelBanter - Can this be done ?

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

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

- - Can this be done ? (https://www.excelbanter.com/excel-discussion-misc-queries/183100-can-done.html)

Eric @ BP-EVV

Can this be done ?

Is it possible to use an Excel spreadsheet to gather parameters, then use
those parameters in a SQL query against a table on a SQL server database, and
then return the results back to Excel ?

I'd like to create some reports for users so that they can run at will from
Excel.

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