View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_3_] NickHK[_3_] is offline
external usenet poster
 
Posts: 415
Default How to execute parametrised stored procedure from MS query?

Otto,
Using ADO ?

Check the Command and .CommandType, .Parameters.Add etc.
I seem to remember that even though there is a
comm.CommandType = adCmdStoredProc
you need to use
CommandType = adCmdText
for this to work.

NickHK

"Otto4444" ...
Hi !
How to execute a parametrised stored procedure from MS query to MS SQL
database? If it's possible.

Regards
Otto