Export SQL Table Data in Excel

1. Right click on your database. Go to=> Task option=>then Click on Export data option.

2. Click on next button.

3. Then choose Datasource and server name and your database and your authentication type. And then click next button.

4. After that choose your destination DataSource excel and browse your excel file along with choosing your Excel version. And click next.

5. Select copy data from one or more table option and click next button.

6. Check the table name from the list of table which you want to export to excel. And click the next button.

7. Click Next and Finish and you can see the output in your excel sheet file.