EXTRACT DATA TO A .CSV - Comma Separated Values

• Tyler Gansk

  Grasshopper

  Points: 19

  More actions

  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

• gljjr

  SSChampion

  Points: 10080

  More actions

  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.