How To Run A Stored Procedure with dynamic variables in EXCEL

Noelskie

New member
Joined
Nov 26, 2014
Messages
1
Reaction score
0
Points
0
Good Morning Guys,

I Would like to ask how could you run a stored procedure that has dynamic variables(Will Allow you to input variables before you run the stored procedures). i am trying to use a stored procedure by calling it in. i have attached my connection settings and hopefully you can help me guys on this problem. by the way, i am using excel 2013 to run my stored procedure.

Many Thanks,

Noel


Capstone Connection Settings.jpg
 
I always use ADO and call the stored procedure using the Command object, in which you can set parameters.
 
Back
Top