Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    5

    Unanswered: output table to text file

    I would like to output the content of a table into a text file and the opposite copy values stored in a text file into a table.

    How can i achieve this writing SQL code?

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Easiest way is bcp.
    Can use bulk insert or bcp for the import.

    see
    http://www.nigelrivett.net/WriteTextFile.html
    http://www.nigelrivett.net/ImportTextFiles.html

Posting Permissions

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