Post reply

Passing Stored Procedure Parameters

  • September 5, 2007 at 9:20 am

    #91346

    I have a SP that I would like to use to import data into Excel Service.  My SP requires three parameters, @Loc, @Start, @End.  I need the user to be able to enter these three parameters in the sheet, but I have not been able to figure this out.  Any help is greatly appreciated!

    Frederick (Fred) J. Stemp, Jr.
    Database Administrator / Database Developer
    Dealer Funding, LLC

    '...if they take my stapler then I'll set the building on fire...'

  • September 5, 2007 at 2:18 pm

    #731613

    You're going to need to write a VB macro or put a button on your sheet, something like that. The users would fill out specific cells with the values that they want for the parameters, and then you would use those values in your stored procedure call.

  • September 5, 2007 at 2:39 pm

    #731617

    Normally I would but in Excel Services VBA and Macros are not supported.  I was hoping someone had found a work around

    Frederick (Fred) J. Stemp, Jr.
    Database Administrator / Database Developer
    Dealer Funding, LLC

    '...if they take my stapler then I'll set the building on fire...'

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply