Excel SQL Query of an External SQL table with parameters
Posted on 2014-01-04
Select [Attending Physician],[AdmitDateTime],[Patient Name],[Account Number]
Above is the SQL statement to retrieve data from a SQL table into a workbook tab. I want the user to input a beginning and ending date into two workbook cells, let's say Sheet2.B2 and Sheet2.B3.
What is the syntax to modify the statement to use the values in these two cells to create the WHERRE clause for the SQL statement above?