Hi all,
I just need an idea (not code) how to export data from my databse to excel sheet..that too row wise..
I only need a starting idea... m using Visual studio 2008.
Piya27
4
Junior Poster
Recommended Answers
Jump to PostOne way to export data to an (existing) Excel file is to use OleDb (namespace System.Data.OleDb). Check out Connection strings for Excel how to form a proper connection string to access an Excel …
Jump to PostWhat database are you using? You can also use Excel automation to extract the data but I would use the OleDb approach outlined above.
All 8 Replies
Piya27
4
Junior Poster
Teme64
215
Veteran Poster
sknake
1,622
Senior Poster
Featured Poster
Piya27
4
Junior Poster
Piya27
4
Junior Poster
Piya27
4
Junior Poster
Karthick N
0
Newbie Poster
Piya27
4
Junior Poster
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.