Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return a stored procedure value to Excel
I have a stored procedure that returns a single value from an SQL table, uses
that value to wite data into another SQL table and increments the original value by 1. I can invoke the procedure from excel using ADO, but I can't return the value into excel for further processing. Can anyone help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return a stored procedure value to Excel
You need to look at the Parameters of the ADODB.Command object.
And the .Direction of each Parameter you set. NickHK "nurkus" wrote in message ... I have a stored procedure that returns a single value from an SQL table, uses that value to wite data into another SQL table and increments the original value by 1. I can invoke the procedure from excel using ADO, but I can't return the value into excel for further processing. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data return from SQL Stored procedure... | Excel Discussion (Misc queries) | |||
OLEDB - INSERT INTO Excel FROM Stored Procedure | Excel Programming | |||
execute stored procedure from excel | Excel Worksheet Functions | |||
Getting stored procedure result to excel | Excel Programming | |||
Run a stored procedure in Excel 2K | Excel Programming |