Output param from SQL
 

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

Output param from SQL
 

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

NickHK

"Andre" wrote in message
...
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