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
Join the conversation! Your thoughts help the community grow.