How can I embed a parameter for a stored proc into MS Query?

G

Gail J-N

I need to run an MS SQL Server 2005 stored proc from MS query, but I'd really
like to be able to pass one single parameter for the stored proc to MS Query
(or VBA??) from Excel. Is there a way to do that?

E.g. my stored proc is: ABCD '200801' where '200801' is an input parameter.

I'd like to have a user update an Excel field as '200802', and then have a
way that MS Query (or something) executes the SQL stored proc using the new
parameter (e.g. ABCD '200802').

Can that we done?

Thanks in advance!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Execute SQL Stored Proc from Access 1
Error in row -2147467259 calling sql stored proc from excel 2003 3
Setting Connection Property to pass 3 parameters to an SQL Proc. 2
SQL Stored proc - passing parameters 1
Referncing stored proc from a form 2
Best way to call a SQL Server Stored Procedure from within Excel 2
Parameter query? 1
Passing dates to Sql Server 2005 stored procedure 3

Top