Getting Data from SQL Server through .Net to Excel

If I have a datatable in .Net and want to save it to Excel, what are the events i need to call. The information is coming from a SQL Server DB and populates the datatable. If I do not have to assign the data to the datatable first, then that would cut out some of the clutter in the code. Thank you in advance!

Excel 2003, SQL Server 2000, ASP.Net


Answer this question

Getting Data from SQL Server through .Net to Excel

  • KrzysztofP

    theres a good microsoft kb on this here

    Cathal

  • Getting Data from SQL Server through .Net to Excel