execute stored procedure from excel

[Guest]

Hi,

I have created procedure ProcA that creates a table TblA in SQL

how do i call the stored procedure from Excel to execute that stored
procedure ?

appreciate any advise

tks & rdgs

 

[Guest]

You've posted 63 questions to this forum and never indicated that anyone had
ever answered your question satisfactorily?

That said...
I THINK you might want to try...

DATA / GET EXTERNAL DATA / RUN SAVED QUERY

HTH,

 

[Guest]

Hi Gary,

My appologies for posting the same question in Excel - Programming as i
tot i have posted but yet i could not find my posting

as for my indication of whether the reply has been successful , i did not
realise that i actually need to do that

as for my ques , is there any way to do it programmatically ?
this is how i write my code :

====================================
Dim strConn As String
Dim con As Connection
Dim comm As ADODB.Command
strConn = "Provider=SQLOLEDB;Data Source=SvrA;InititalCatalog
=master;uid=;pwd="

Set con.Execute = strConn
Set comm = New Command
comm.ActiveConnection = con
comm.CommandText = "SQL1.master.dbo.Usr_GetUserAccess"
comm.CommandType = adCmdStoredProc
'comm.ActiveConnection = strConn
comm.Execute strConn

Set rs = New ADODB.Recordset
rs.Open "Select * from [UserAccess]", con

=====================================

but i have some problem using the connection objects

appreciate your advise
rdgs,

 

[Guest]

Try turning on the Macro Recorder...
TOOLS / MACRO / RECORD NEW MACRO
Then run your query using...
DATA / GET EXTERNAL DATA / RUN SAVED QUERY
Then review the code that was created. It may put you on the right track.
HTH,
--
Gary Brown
(e-mail address removed)

Hi Gary,

My appologies for posting the same question in Excel - Programming as i
tot i have posted but yet i could not find my posting

as for my indication of whether the reply has been successful , i did not
realise that i actually need to do that

as for my ques , is there any way to do it programmatically ?
this is how i write my code :

====================================
Dim strConn As String
Dim con As Connection
Dim comm As ADODB.Command
strConn = "Provider=SQLOLEDB;Data Source=SvrA;InititalCatalog
=master;uid=;pwd="

Set con.Execute = strConn
Set comm = New Command
comm.ActiveConnection = con
comm.CommandText = "SQL1.master.dbo.Usr_GetUserAccess"
comm.CommandType = adCmdStoredProc
'comm.ActiveConnection = strConn
comm.Execute strConn

Set rs = New ADODB.Recordset
rs.Open "Select * from [UserAccess]", con

=====================================

but i have some problem using the connection objects

appreciate your advise
rdgs,

You've posted 63 questions to this forum and never indicated that anyone had
ever answered your question satisfactorily?

That said...
I THINK you might want to try...

DATA / GET EXTERNAL DATA / RUN SAVED QUERY

HTH,