How to export the data from database to excel

http://searchsqlserver.techtarget.com/feature/The-SQL-Server-Import-and-Export-Wizard-how-to-guide


and you can use macros as well to export data in excel from DB directly.

http://www.codeproject.com/Tips/659666/Export-very-large-data-to-Excel-file
http://www.c-sharpcorner.com/UploadFile/83fe73/solutions-to-export-data-from-database-to-excel-in-C-Sharp/