Export a DataTable to Excel

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Daniel
    #1

    Export a DataTable to Excel

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

    How do I do this? Using VB 2005 Express.

    Thanks!
    Daniel

    Tags: None
    • rowe_newsgroups
      #2
      Re: Export a DataTable to Excel

      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:
      I have a DataSet that consists of two Tables (made from TableAdapter
      Queries). I want to export each of these to an Excel spreadsheet
      programmaticall y after the Fill method completes.
      >
      How do I do this? Using VB 2005 Express.
      >
      Thanks!
      Daniel

        Comment

        Previous template Next
        Working...