execute stored procedure from excel
 

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

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,
--
Gary Brown



"maxzsim" wrote:

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

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" wrote:

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,
--
Gary Brown



"maxzsim" wrote:

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

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



"maxzsim" wrote:

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" wrote:

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,
--
Gary Brown



"maxzsim" wrote:

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