Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 196
  • Last Modified:

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?
0
lobos
Asked:
lobos
  • 2
1 Solution
 
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
 
topdog770Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now