You must Sign In to post a response.
  • Category: SQL Server

    SQL server to excel

    how to export data from sql server to excel using sql query?
  • #756994
    You can create excel from sql server in different way.
    1.The best way you can use inbuilt Export to excel feature of sql server to get excel file even you want to fetch using sql query for filter result.

    2.You can create excel file using BCP command with sql query.

    3.you can get excel using OPENROWSET with using Microsoft.Jet.OLEDB.4.0.

    4.Simple way you just select query in sql sever management studio and copy result set from result pane and paste into new excel sheet.

    Regards & thanks
    Arvind kumar
    Visit--blog.akumars.esoftera.in

  • #756995
    Thanks for your reply.
    I want export data from sql server to new excel using sql query. I want to Copy/Paste method.


  • Sign In to post your comments