execute stored procedure from excel

M

maxzsim

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
 
G

Gary Brown

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,
 
M

maxzsim

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,
 
G

Gary Brown

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
[email protected]


maxzsim said:
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,

Gary Brown said:
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,
Click to expand...
Click to expand...
 
Top