Thread: Calling stored proc with parameters ..
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harish Mohanbab[_3_] Harish Mohanbab[_3_] is offline
external usenet poster
  
Posts: 1
Default Calling stored proc with parameters ..

Hi,

How to call a stored proc with parameters from Excel VBA? Withou
parameters, it goes something like -

.................................................. ......
Set Comm = New ADODB.Command
Comm.ActiveConnection = Conn
With Comm
.CommandText = <STORED PROC NAME
.CommandType = adCmdStoredProc
.Execute
End With
.................................................. ......

But I am not able to call SP with multiple parameters. Can someon
help please.

Thanks in advance,

Harish Mohanbab

--
Harish Mohanba

-----------------------------------------------------------------------
Harish Mohanbab's Profile: http://www.excelforum.com/member.php...nfo&userid=633
View this thread: http://www.excelforum.com/showthread.php?threadid=46818

Reply With QuoteReply With Quote