In my previous article, I discussed how to import data from Excel sheet to SQL server. Here, I am explaining how to export data from SQL Server to Excel sheet.

Here is my SQL server database.


And inside this database here is my table.



And here is my empty Excel sheet.


Step 1: For exporting work please perform the following steps.



Step 2: Click NEXT on EXPORT AND IMPORT window.
Step 3: Fill your source (SQL server ) details and click NEXT.


Step 4: Fill all the Destination details (Excel sheet).



Step 5: Choose the above radio button and click Next.



Step 6: Map the source with destination.



Step 7: You can map it like this by clicking (Edit Mapping).



Step 8: Click OK and Next.



Step 9: Click Next.



Step 10: Click Next.


Now if you will check your excel sheet you will find all the data there.


Thus in this way you can export data from SQL server to excel sheet.