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

    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
    Posts
    2
    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 : http://www.dbforums.com/microsoft-ex...-ms-query.html

    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 :

    http://www.querycell.com/call-sql-se...rom-excel.html

    Cheers
    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
  •