Export table to dbf file

[Randy Henson]

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

[John Bell]

Hi

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" <rh*****@cellxion.com> wrote in message
news:5d**************************@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