Output param from SQL

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
 
N

NickHK

Andre,
Look in to ADO, especially the Command object and it's Parameter property.

NickHK
 

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
A value copy, not reference, of SqlParameter? 6
Best way to call a SQL Server Stored Procedure from within Excel 2
Error in row -2147467259 calling sql stored proc from excel 2003 3
Passing dates to Sql Server 2005 stored procedure 1
output param returns array 3
Retrieve varbinary from SqlServer using OUTPUT params in StoredPro 3
getting back my sql table @@IDENTITY 2

Top