Output param from SQL

  • Thread starter Thread starter Andre
  • Start date Start date
A

Andre

I want to call a SQL stored proc from Excel VBA and get an output param, but
don't know how to do this. Can someone point me in the right direction?

Basically what I'm doing is taking 2 cell's value and feeding them to a
stored proc. The stored proc loads the data into a table. The table has an
identity column. The sproc gets the identity value using SCOPE_IDENTITY. I
want the Identity value returned to Excel.

Any help or URL's with examples would be greatly appreciated.

Thanks, Andre
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Stored proc - passing parameters 1
Passing dates to Sql Server 2005 stored procedure 1
A value copy, not reference, of SqlParameter? 6
Error in row -2147467259 calling sql stored proc from excel 2003 3
Looking for Comments on Code 5
getting return value from stored proc 4
Retrieve varbinary from SqlServer using OUTPUT params in StoredPro 3
Best way to call a SQL Server Stored Procedure from within Excel 2

Back
Top