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? |
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? |
All times are GMT +1. The time now is 05:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com