Export a DataTable to Excel

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

I have a DataSet that consists of two Tables (made from TableAdapter
Queries). I want to export each of these to an Excel spreadsheet
programmatically after the Fill method completes.

How do I do this? Using VB 2005 Express.

Thanks!
Daniel
 
You should look up excel's querytables. Create a SQL command that would
pull the necessary info from the dataset and then base the querytable
off of that.

Thanks,

Seth Rowe
 
Back
Top