Results 1 to 4 of 4
  1. #1
    Join Date
    May 2008
    Posts
    5

    Question Unanswered: How to copy one table to text file

    Hello:

    I want to copy one table not whole database to text file. How to do it? Using DTS could not allow me to select the specific table.

    Thanks,

    Snow

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Easiest way is to use the BCP utility. It is a command line utility, so you can get the basic usage by bcp /?

  3. #3
    Join Date
    May 2008
    Posts
    5

    How to copy one table to text file

    Hello:

    Thanks for the reply. How to access bcp?

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    You use BCP either via the command line or you can use the xp_cmdshell extended procedure. The specific syntax is available in books online.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •