How do I export SQL data into a text delimited file?

  • How do I export SQL data into a text delimited file using SQL 2000? Need the script.

    SELECT date,customer_id,office,region

    FROM customer

    where date = '2008-07-10'

    ORDER BY date

    Need data in a text file like this:

    date,customer_id,office,region

    01/19/2008,70188,4,11

    01/21/2008,70188,14,28

    01/22/2008,70188,19,35

    01/23/2008,70188,12,34

    01/24/2008,70188,6,20

    01/25/2008,70188,19,42

    01/26/2008,70188,,8

    01/28/2008,70188,22,47

    01/29/2008,70188,9,36

    01/30/2008,70188,,24

    01/31/2008,70188,12,40

    02/01/2008,70188,16,42

    02/02/2008,70188,,11

  • One time thing or a process?

    One time, use QA. run the query, right click the upper left, save as.

    Process, use DTS. The data export wizard will help you build the package.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply