Export table to dbf file

I need to export certain fields of a table from sql 2000 into a dbf
file, but can't find the proper query command to make it work. I also
want to set this up to run each night automatically.

Any help will be greatly appreciated.

RandyHi

You will probably need a scheduled DTS job, check out Books online for more
information about DTS and the following site is also very useful
http://www.sqldts.com/default.aspx

John

"Randy Henson" <rhenson@.cellxion.com> wrote in message
news:5dde95d2.0308220515.1232d9b5@.posting.google.c om...
> I need to export certain fields of a table from sql 2000 into a dbf
> file, but can't find the proper query command to make it work. I also
> want to set this up to run each night automatically.
> Any help will be greatly appreciated.
> Randy