Export table to dbf file

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Randy Henson
    #1

    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
    Tags: None
    • John Bell
      #2
      Re: Export table to dbf file

      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" <rhenson@cellxi on.com> wrote in message
      news:5dde95d2.0 308220515.1232d 9b5@posting.goo gle.com...[color=blue]
      > 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[/color]


        Comment

        Previous template Next
        Working...