Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Query
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Query
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Query
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 "Dmeade" wrote in message ... 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |