471,092 Members | 1,504 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

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.

Randy
Jul 20 '05 #1
1 8955
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

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Matt | last post: by
1 post views Thread by Do Park via SQLMonster.com | last post: by
6 posts views Thread by Oliver Stratmann | last post: by
3 posts views Thread by nologin | last post: by
3 posts views Thread by Edward Reid | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.