Post reply

EXTRACT DATA TO A .CSV - Comma Separated Values

  • February 6, 2004 at 4:49 pm

    #107260

    Hi All,

    Might someone be able to point me in the direction of a script

    that I can build to be executed to pull all the data or "some" (where =)

    data from a SQL Serv. DB into a .CSV?

    Thnx

  • February 6, 2004 at 6:41 pm

    #493186

    If you return the results in Query Analyzer to a grid you can then save the results in CSV format. Unfortunately you can't save the column settings that way. Another way is to use DTS packages to export the query results to a text file and then specify the format you want on export. A little more complicated but very powerful.




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

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

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