select certain column to .csv file

• eng.sarah.kandil

  Grasshopper

  Points: 10

  More actions

  June 25, 2014 at 2:47 pm

  #295903

  I have a database it is 50 gb with hundreds of columns

  I would like to choose a certain column and convert the data in it to .csv or excel file

  How can I do that I am very new to MSSQL

  Thanks in advance

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  June 25, 2014 at 2:51 pm

  #1724840

  * if the excel needs to be formatted, I would create a report in SSRS and export to Excel

  * bcp

  * SSIS

  * Import/Export wizard

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP