How to export data to excel from sql database

Posted by Manbkp under ASP.NET on 8/4/2013 | Points: 10 | Views : 706 | Status : [Member] | Replies : 2
I want to export data from sql database to my excel sheet of employee detail.
Export can be done from 4th row of excell file and first three row should be company detail and information.
Help please.




Responses

Posted by: Bandi on: 8/5/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
You can use the following methods:
1) Import/Export Wizard is available under Microsoft SQL Server Folder in "All Programs"
2) Right-click on Database in which you have the table --> Tasks --> Export Data --> follow the wizard and check in the option "Append data" to achieve your second requirement. ( Make sure to first create the excel file with your company details )
3) BCP command for export data ( google it)


Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Manbkp, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rimi1289 on: 8/6/2013 [Member] Starter | Points: 25

Up
0
Down
Wizard are simple and used all over.

Manbkp, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response