Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Export Database Question
0 views
Skip to first unread message
Ash
Mar 16, 2002, 5:00:51 AM3/16/02
to
Hi,
I have Sql 2000 running on Windows 2000 server. The thing i want to do is,
export a specific table to an excel format.
Because i'll have to export this everyday, i am looking for a method that
will automatically export the file to some specific folder everyday, instead
of me manually doing it through the Enterprise manager.
Looking forward to some help,
Thank you,
Ash
Bob Pfeiff [MS]
Mar 16, 2002, 12:40:00 PM3/16/02
to
Your best bet is to create a Data Transformation Services (DTS) package to
do this, Excel is one of the built-in data sources/destinations. You can
then schedule the DTS package using SQL Agent. There is a lot of info on
this in books online.
do this, Excel is one of the built-in data sources/destinations. You can
then schedule the DTS package using SQL Agent. There is a lot of info on
this in books online.
--
Bob
Microsoft Consulting Services
------
This posting is provided AS IS with no warranties, and confers no rights.
0 new messages