Export to Excel from SQL Server using T-SQL script

Export to Excel from SQL Server using T-SQL script

This post helps in understanding Export to Excel from SQL Server using T-SQL Script. Typically to export data from sql server to excel we can user varius options :

  • Import / Export Wizard
  • BCP
  • OPENROWSET

Below stored procedure will make the task easier. It provides more flexibility to Export to Excel from SQL Server using T-SQL script. .

 

 

Posted in SQL Development, SQL Scripts | Tagged , , , , | Leave a comment

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz