I would like to set param values for a stored procedure and then execute the insert sp from excel. Is this possible?

Hi Mike,

It's possible using VBA code. You can use an ADODB.Command object to execute the stored procedure.

And it's possible without writing VBA by using MS Query. I think this has previously been covered in the forums at : Executing Stored Procedures Within MS Query

Also add-ins such as QueryCell (Which is my add-in) and the SQLDrill add-in support executing stored procedures.

There is an example here :

http://www.querycell.com/call-sql-se...rom-excel.html

Cheers
Sam Howley