How to Copy SQL Table into Excel and Other Formats

How to take SQL Table into Excel and Formats

1. Open ssms2012->databases->sample database

2. Click that export data ther is a new window open like below.

 

3. Choose the datasource,there is a lot of datasources dropdownded here,

4. Choose the source database here dbo.sample is a source database.

5. Here you choose designation Database or other foramts like oldb,excel formats

6. Then excel file path

7. Select the first radio button for copy or second radio button for query to write the data choose any one

8. Click next->select table you want to copy

9. If you want edit the columns means you have to use this window editmapping

10. You can check the preview for here

11. Click next

12. Finish

13. After click finish you can see files can be transferred like below

14.Go to->myDocuments open the excel file already you created and all datas come to excel sheet that's all