export stored proc from sql server to access db

26 Aug 2006 8:05 AM

ads

how do i include stored procedures in sqlserver2000 in dts export to access
database?only tables and views were exported

Thanks.

26 Aug 2006 8:15 AM

Arnie Rowland

You don't!

Access cannot execute stored procedures, so there is no provision in an
Access database (mdb) for stored procedures.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

Show quote

"ads" <a**@discussions.microsoft.com> wrote in message
news:659707E5-D5E7-4F54-B6D3-A045E02224D4@microsoft.com...
> how do i include stored procedures in sqlserver2000 in dts export to
> access
> database?only tables and views were exported
>
> Thanks.

28 Aug 2006 3:53 AM

ads

i know access cant execute stored procedures but is there a way i can convert
stored procedures in sql server to stored queries in access? i have over 60
stored procedures and converting them one by one will be a tedious job.

Show quote

"Arnie Rowland" wrote:

> You don't!
>
> Access cannot execute stored procedures, so there is no provision in an
> Access database (mdb) for stored procedures.
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
>
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
>
> "ads" <a**@discussions.microsoft.com> wrote in message
> news:659707E5-D5E7-4F54-B6D3-A045E02224D4@microsoft.com...
> > how do i include stored procedures in sqlserver2000 in dts export to
> > access
> > database?only tables and views were exported
> >
> > Thanks.
>
>
>

28 Aug 2006 2:20 PM

Jim Underwood

This is pretty much impossible.

SQL Server stored procs work with different SQL syntax than access, but this
is the simplest thing to correct.

Stored procs allow for a lot of procedural code which you cannot do in
Access, making any automatic conversion impossible.

SQL Server also has many proprietary features that simply don't exist in
Access.

Aside from the fact that doing this automatically is impossible, why in the
name of all thats good are you converting from SQL Server to access? This
is like trying to convert a Porshe to a horse and buggy, without the horse.

Show quote

"ads" <a**@discussions.microsoft.com> wrote in message
news:72FCDB5B-3608-44BA-82A4-018A8E848E76@microsoft.com...
> i know access cant execute stored procedures but is there a way i can
convert
> stored procedures in sql server to stored queries in access? i have over
60
> stored procedures and converting them one by one will be a tedious job.
>
> "Arnie Rowland" wrote:
>
> > You don't!
> >
> > Access cannot execute stored procedures, so there is no provision in an
> > Access database (mdb) for stored procedures.
> >
> > --
> > Arnie Rowland, Ph.D.
> > Westwood Consulting, Inc
> >
> > Most good judgment comes from experience.
> > Most experience comes from bad judgment.
> > - Anonymous
> >
> >
> > "ads" <a**@discussions.microsoft.com> wrote in message
> > news:659707E5-D5E7-4F54-B6D3-A045E02224D4@microsoft.com...
> > > how do i include stored procedures in sqlserver2000 in dts export to
> > > access
> > > database?only tables and views were exported
> > >
> > > Thanks.
> >
> >
> >

29 Aug 2006 3:51 AM

ads

lol.because we need to run a website in cds aside from publishing the website
in the internet. to do this we will need to purchase a 3rd party stand alone
web server that runs in cds and the only one i can find supports asp.net2.0
and access database as data storage.

This is done to reduce further coding.

Any suggestions are welcome.

Thanks.

Show quote

"Jim Underwood" wrote:

> This is pretty much impossible.
>
> SQL Server stored procs work with different SQL syntax than access, but this
> is the simplest thing to correct.
>
> Stored procs allow for a lot of procedural code which you cannot do in
> Access, making any automatic conversion impossible.
>
> SQL Server also has many proprietary features that simply don't exist in
> Access.
>
> Aside from the fact that doing this automatically is impossible, why in the
> name of all thats good are you converting from SQL Server to access? This
> is like trying to convert a Porshe to a horse and buggy, without the horse.
>
> "ads" <a**@discussions.microsoft.com> wrote in message
> news:72FCDB5B-3608-44BA-82A4-018A8E848E76@microsoft.com...
> > i know access cant execute stored procedures but is there a way i can
> convert
> > stored procedures in sql server to stored queries in access? i have over
> 60
> > stored procedures and converting them one by one will be a tedious job.
> >
> > "Arnie Rowland" wrote:
> >
> > > You don't!
> > >
> > > Access cannot execute stored procedures, so there is no provision in an
> > > Access database (mdb) for stored procedures.
> > >
> > > --
> > > Arnie Rowland, Ph.D.
> > > Westwood Consulting, Inc
> > >
> > > Most good judgment comes from experience.
> > > Most experience comes from bad judgment.
> > > - Anonymous
> > >
> > >
> > > "ads" <a**@discussions.microsoft.com> wrote in message
> > > news:659707E5-D5E7-4F54-B6D3-A045E02224D4@microsoft.com...
> > > > how do i include stored procedures in sqlserver2000 in dts export to
> > > > access
> > > > database?only tables and views were exported
> > > >
> > > > Thanks.
> > >
> > >
> > >
>
>
>