stored procedures

  1. A

    Create SQL table from Excel VBA

    Hello - I have the following table in Excel <tbody> SLCo SL CompCode APRef Amount Release 101 19 CM 967 5000 101 19001-01P CM 19001-0719 10500 X 101 123546-A CM 123658-1 15000 X 101 56875-4 CM 9856-7A 7500 X 101 32587-4 CM 5647-8 21500 </tbody> Using VBA on a button, I'd like...
  2. B

    View Stored Proc Command Text in a Cell

    Hi, I'm working on a Macro that is working intermittently to change the Command Text in a Stored Proc connection property. e.g. exec dbo.usp_ShepherdBonusDataBreakdown 'Sonya Taylor',7,2013 Changes to [SurveyorName] based upon 'Variables' Range "E4" With Workbooks("Surveyor Statement...
  3. S

    Output from stored procedures

    I am trying to use some stored procedures in Oracle. I've tried to use the upload-function with objConnection.Execute "BEGIN upload_from_excel(1, 2, 3 ,4); END;", but I don't know how to get any response if the query didn't run successfully. Is there a way to do this in VBA? I've found that I...
  4. megnin

    How to call a Stored Procedure with parameters

    Hi, I've tried adapting some VBA code from other posts and I'm not having any luck with this. I could really use some help. I have a Stored Procedure in my SQL 2005 database called: sp_Count_All_YN_Answers_WTP It contains these parameters: @OneStop varchar(50) = '%', @CaseManagerLName...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top