Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
open a spreadsheet with param | Excel Discussion (Misc queries) | |||
build param string for WHERE IN (....) | Excel Programming | |||
Haeder/Footer param | Excel Programming | |||
PrintToFile param - what's the file format? | Excel Programming | |||
CorruptLoad param of Workbooks.Open | Excel Programming |