i want to export all data in sql 2005 database to excel file but i don't know!
Please help me!
Thanks so much!
thuyson
0
Light Poster
Recommended Answers
Jump to PostExport 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
Jump to PostOk, 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 …
All 5 Replies
Ionelul
7
Junior Poster in Training
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
thuyson
0
Light Poster
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.
thuyson
0
Light Poster
Thanks your reply!
junaidmuet
0
Newbie Poster
i want to export Selected sql database from dropdownlist to excel sheet
plz reply fast
Lusiphur
185
Practically a Posting Shark
Team Colleague
Featured Poster
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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.