Generating an Excel spreadsheet from vb.net forms!

[China Gary]

Any help/guidance with this would be much appreciated! Im working on developing a system that ultimately generates a timetable of events, much like an timetable for a track event, allocating people to lanes etc.. I need to be able to generate an Excel spreadsheet that is populated with the data that is held within my text boxes and labels in my forms, all Strings btw. Is there a way that i can submit an event/race to the spreadsheet, go back and submit another race that will appear underneath the race already submitted, without overwriting what is already in the spreadsheet?? I would be very grateful for help here, and have explained it as i see the nature of the problem! Thanks

[andyharman]

Try http://support.microsoft.com/kb/316934[^] It allows you to treat MS-Excel like a database table so that you can append new records. Alternatively, if you create an HTML file then rename it to have a ".XLS" extension then Excel will treat it like any normal spreadsheet.

[China Gary]

Thanks, ill try it out! Appreciate the help! :)