var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: insert values from excel to sql server
I would like to set param values for a stored procedure and then execute the insert sp from excel. Is this possible?
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 : http://www.dbforums.com/microsoft-ex...-ms-query.html
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 :