Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: insert values from excel to sql server

    I would like to set param values for a stored procedure and then execute the insert sp from excel. Is this possible?

  2. #2
    Join Date
    Jul 2009
    Hi Mike,

    It's possible using VBA code. You can use an ADODB.Command object to execute the stored procedure.

    And it's possible without writing VBA by using MS Query. I think this has previously been covered in the forums at :

    Also add-ins such as QueryCell (Which is my add-in) and the SQLDrill add-in support executing stored procedures.

    There is an example here :

    Sam Howley

Posting Permissions

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