How to Export a query to a csv file

• scrocker

  SSC Veteran

  Points: 231

  More actions

  February 25, 2005 at 9:36 am

  #163705

  I hope that this is the correct place to put this information.

  I have a database that I need to export a query to a csv or xls file.  What is the easiest way to do that in Query Analyzer or create a view and export from the view?

  Thanks

   

• Osoba

  SSCommitted

  Points: 1964

  More actions

  February 25, 2005 at 9:48 am

  #544195

  Query Analyzer.

  Choose Query-->Results to file-->Name and save.  The query will run and save it as a file.

   

  ..hope that helps