Return a stored procedure value to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You need to look at the Parameters of the ADODB.Command object.
And the .Direction of each Parameter you set.

NickHK
 
Back
Top