Posted to microsoft.public.excel.programming

external usenet poster

Posts: 1

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

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!!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
run stored proc from excel with a parameter	TG	Excel Programming	1	November 20th 07 02:58 PM
executing stored proc from Excel	doofy	Excel Programming	2	June 5th 07 06:43 PM
SQL Stored proc - passing parameters	Harish Mohanbabu[_3_]	Excel Programming	1	April 20th 06 05:55 PM
DAO recordset Call to SQL Stored Proc	Datasort	Excel Programming	0	December 1st 05 06:06 PM
execte stored proc	maxzsim	Excel Programming	1	May 10th 05 05:50 PM

All times are GMT +1. The time now is 08:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us