MS Query

[David]

I am trying to use MS query to return data from a SQL Server Database
using an existing stored procedure.

How can I pass parameters to the sp from MS query? I'd like to keep
the parameters in worksheet cells.

Thanks

 

[Dmeade]

I just discovered this trick and it's very cool. Set up
your parameters in MS query using the brackets []. The
first time you return data to Excel, it will prompt you
for values.

After the query is in Excel, right-click in the query
range. You will see a Parameter choice on the menu.
Click on that, and it will give you the option to specify
a cell location for your parameters.

Diane

 

[David]

What I'm really trying to do is run the SQL Server stored procedure
from MS Query and pass the parameters that the stored procedure needs
in order to run.

Thanks.
Dave

I just discovered this trick and it's very cool. Set up
your parameters in MS query using the brackets []. The
first time you return data to Excel, it will prompt you
for values.

After the query is in Excel, right-click in the query
range. You will see a Parameter choice on the menu.
Click on that, and it will give you the option to specify
a cell location for your parameters.

Diane

-----Original Message-----
I am trying to use MS query to return data from a SQL Server Database
using an existing stored procedure.

How can I pass parameters to the sp from MS query? I'd like to keep
the parameters in worksheet cells.

Thanks
.