Hello,
I would like to have a date field in Excel which is then used in my connection SQL query. I have found the advice in the below link but the problem with that is that it involves a stored procedure and also I have multiple date ranges.
https://www.mssqltips.com/sqlservertip/3436/passing-dynamic-query-values-from-excel-to-sql-server/
Does anyone have any idea about how to do this please?
Thanks
I would like to have a date field in Excel which is then used in my connection SQL query. I have found the advice in the below link but the problem with that is that it involves a stored procedure and also I have multiple date ranges.
https://www.mssqltips.com/sqlservertip/3436/passing-dynamic-query-values-from-excel-to-sql-server/
Does anyone have any idea about how to do this please?
Thanks