In this article I am going to explain how to export data to excel file using SQL Server export data wizard.
There are many ways to export data to excel from SQL server. Here I am going to explain how you can export the data to excel file using export data wizard. This feature is available in SSMS (SQL Server management Studio).
Open SQL Server management Studio and connect to server. Right on database from which you want to export the data. Here I have select Northwind database. Right click on it, go to Task and select Export data.