Export SQL Server tables to Access

Hi,
Is there any query in SQL Server2000 that will export all the tables
from Current Database to MS Access database with all data?
Thanks in advance
MadhivananDTS?
<madhivanan2001@.gmail.com> wrote in message
news:1109158780.131816.94360@.g14g2000cwa.googlegroups.com...
> Hi,
> Is there any query in SQL Server2000 that will export all the tables
> from Current Database to MS Access database with all data?
> Thanks in advance
> Madhivanan
>|||Hi
Look at Data Transformation Services (DTS) in BOL. This will do it for you.
Regards
Mike
"madhivanan2001@.gmail.com" wrote:

> Hi,
> Is there any query in SQL Server2000 that will export all the tables
> from Current Database to MS Access database with all data?
> Thanks in advance
> Madhivanan
>|||Madhivanan,
You can use the Export wizard in Enterprize Manager.
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
<madhivanan2001@.gmail.com> wrote in message
news:1109158780.131816.94360@.g14g2000cwa.googlegroups.com...
> Hi,
> Is there any query in SQL Server2000 that will export all the tables
> from Current Database to MS Access database with all data?
> Thanks in advance
> Madhivanan
>|||Thanks for all of your replies.
But I want to do this by using VB6 application. Is there any way to do
the export function without using wizard?
Madhivanan|||Yes, you can call a DTS from VB application
<madhivanan2001@.gmail.com> wrote in message
news:1109162768.679373.273560@.l41g2000cwc.googlegroups.com...
> Thanks for all of your replies.
> But I want to do this by using VB6 application. Is there any way to do
> the export function without using wizard?
> Madhivanan
>|||In DTS I am able to export only one table to Access. How can I export
all tables?
Madhivanan|||Hi
Perhaps you want to look into Linked Tables in Access.
<madhivanan2001@.gmail.com> wrote in message
news:1109224895.582938.196810@.o13g2000cwo.googlegroups.com...
> In DTS I am able to export only one table to Access. How can I export
> all tables?
> Madhivanan
>|||Without opening SQL or Access, I want to export all the tables with
data to Access.
Is there any way to do this?
Madhivanan|||Yes, i see what you mean
INSERT INTO OPENDATASOURCE(
'Microsoft.Jet.OLEDB.4.0', 'Data Source="\\ServerName\AccessDatabase.mdb";
User ID=Admin;Password='
(...AccessTableName (Col1,col2...)
SELECT col1,col2...FROM SqlServerTableName
<madhivanan2001@.gmail.com> wrote in message
news:1109242364.881201.201400@.z14g2000cwz.googlegroups.com...

> Without opening SQL or Access, I want to export all the tables with
> data to Access.
> Is there any way to do this?
> Madhivanan
>