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


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


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