0

i want to export all data in sql 2005 database to excel file but i don't know!
Please help me!
Thanks so much!

4
Contributors
5
Replies
7
Views
7 Years
Discussion Span
Last Post by Lusiphur
0

Export data through c# code?
Otherwise, from SQL Server Management Studio, right click on your database -> Tasks -> Export Data and follow the steps from the wizard. In the second windows ,"Choose destination", select Microsoft Excel.

Ionut

0

Thank u your reply,but i want to using code.when user press a button,it will export data in sql 2005 to excel file.

0

Ok, some methods have been given already but here's a couple of tutorials to help with different ways of getting DB info to Excel spreadsheet format.

First is a tutorial to do it directly from MS SQL Server

Second is a tutorial on doing it in VB.Net and C# which also includes exports to other file types as well.

Hope this helps :) Mark as solved if your problem has been resolved.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.