Passing parameter from Excel to stored procedure?

H

hmmm...

Greetings. I am writing an Excel application that must pass a user-defined
value to a stored procedure. So far it looks like the only option I have is
going through MSQuery, which does not appear to support passing parameters
to stored procedures. Does anyone know how to do this, either with MSQuery
or a workaround? More info - I am using Office 97. Maybe Office 2000 has
this capability? Thank you.
 
A

Achint Srivastava [MS]

As Patrick mentioned the best way to work around this is to use ADO from
VBA. HEre is an article which shows how to invoke stored procedures from
VBA. It also shows how to pass parameters to the stored procedure.

185125 HOWTO: Invoke a Stored Procedure with ADO Query Using VBA/C++/Java
http://support.microsoft.com/?id=185125

Thanks!
Achint Srivastava
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.
 

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

Using Excel to call Oracle Stored procedure. 1
Passing dates to Sql Server 2005 stored procedure 1
Passing Parameter with OnAction 3
Accessing a Stored Procedure 6
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Updating database table from Excel? 1
Passing parameters to a Web Query 1
Using Stored Procedures With Access Data Project 2

Top