SQL server - Excel
 

Hi!

I know how to pull data from SQL server to Excel but I do not know how to
pass parameters to query from excel cells.

Example:
Cell A2 is begin date, cell B2 is end date. How can I pass those two dates
to Microsoft Query into between function?

Thank you!
/Markonni

SQL server - Excel
 

MarkonniMarkonni wrote:

Try here

http://www.dicks-clicks.com/excel/Ex...htm#Parameters

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Hi!

I know how to pull data from SQL server to Excel but I do not know
how to pass parameters to query from excel cells.

Example:
Cell A2 is begin date, cell B2 is end date. How can I pass those two
dates to Microsoft Query into between function?

Thank you!
/Markonni