Export a DataTable to Excel

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

export datatable to excel 19
Export from VB.NET 2003 to an Excel spreadsheet 3
Export to Excel? 2
Update table SQL Express & VS 2005 1
Stupid Question..Maybe 3
exporting dataset to Excel is slow 6
How to export excel from dataset 1
Select Value From Specific Table Column in TableAdapter 3

Top