Results 1 to 2 of 2

Thread: How To Run A Stored Procedure with dynamic variables in EXCEL

  1. #1

    How To Run A Stored Procedure with dynamic variables in EXCEL



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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


    Click image for larger version. 

Name:	Capstone Connection Settings.jpg 
Views:	116 
Size:	80.6 KB 
ID:	2892

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,663
    Articles
    0
    Excel Version
    O365
    I always use ADO and call the stored procedure using the Command object, in which you can set parameters.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •