vs.2003 and excel

I have a web application I built in 2003 and C# and it works great and all is well. but once and a while I get a request for a dump of all the record in an excel file so the admin can do some quick sorting and other stuff that the application can do.
So I do this manually when requested, but I am wondering because I have never done this before....but is there a way to write in C#, 2003 with framework 1.1 something that would pull all data from a table and write it to an excel file.
If I can automate this, it will make things much easier, but I have never done this before, any examples or experience or feedback on this thought?
lobosAsked:
Who is Participating?
 
topdog770Connect With a Mentor Commented:
Sure!
http://support.microsoft.com/default.aspx/kb/302096
 
This posting has the two other links I was going to add PLUS it has sample code used from web
 http://www.experts-exchange.com/Programming/Programming_Languages/Dot_Net/ASP_DOT_NET/Q_21699087.html
0
 
topdog770Commented:
The very simplest approach is to write the table values to XML.  
'Slightly' more complex, you can write the table values out to a comma separate file, dataDump.CSV, that Excel can easily open.
The CSV route is my personal choice for simple, fast ocassional uses.
If you want to go a little more in depth, it's also possible to write xls files as well.
 
 
0
 
lobosAuthor Commented:
Thanks for your feedback, could you point me in the direction of some samples, or perhaps you have some sample code?
0
All Courses

From novice to tech pro — start learning today.