Home All Groups Group Topic Archive Search About

Export a DataTable to Excel

Author
13 Oct 2006 7:47 PM
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

Author
13 Oct 2006 11:07 PM
rowe_newsgroups
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


Daniel wrote:
Show quoteHide quote
> 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