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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing dates to Sql Server 2005 stored procedure 1
Using Excel to call Oracle Stored procedure. 1
How to store values in excel using macro ? 4
import Excel worksheet to SQL Server table 7
Best way to call a SQL Server Stored Procedure from within Excel 2
Invalid Column Name Sql-Error :Executing a stored procedure 1
Getting stored procedure result to excel 9
Call stored procedure in SSMS from Access 2016 doesn't work. 0

Back
Top