Exporting a View to a CSV

• MarkR-251611

  Right there with Babe

  Points: 731

  More actions

  October 14, 2005 at 9:14 am

  #88187

  How do I export a view to a csv file?

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  October 14, 2005 at 9:31 am

  #597391

  Use DTS, BCP, or Query analyzer.

  For QA you first have to set your results to be comma delimited.

  Tools --> Options --> Results tab --> Results output format pick comma delimited.  Then hit Okay.

  In a query analyzer window select Query --> Results to File.

  Then type select * from Mytable. QA will ask you to give it a file name, and your off.

  See books online for BCP, and dts