Saving Data from Dataset to file

Not at all, you're welcome ;-)

I think I left out a resource because I was able to get past the Excel.Application(); part. The next error was on ds.DefaultViewManager.CreateDataView(ds.Tables(0)). I don't have the exact error on me right now, but it was something along the lines of using it as a method. It didn't like the tables section.

I appreciate all the help, I may tackle this a different way. But thanks for everything! Big help.

I am using Excel 2007, but I would like it to work with 2003 as well. If we can't do that it's fine.

Which version of Excel did you use?

You can export you data from data set to many destinations

To export you data to an xml file

ds.WriteXml(@"C:\myFile");

To export data to a steam

first include

using System.IO;

FileStream oStream = new FileStream(path, FileMode.OpenOrCreate,FileAccess.Write);

ds.writexml(oStream);

to write your dataset content to a text file

using(TextWriter oWriter = new StreamWriter(@"C:\myfile.txt"))
{
    ds.Writexml(oWriter);
   oWriter.Flush();
}

to write your data set to Excel file

DataSet ds = new DataSet();
         DataView oDataView1 = new DataView();
        
        
         Excel.Application oExcel = new Excel.Application();
         Excel.Workbook oWorkBook = new Excel.Workbook();
         Excel.Worksheet oWorkSheet = new Excel.Worksheet();
        
         int i = 0;
         ds.ReadXml(@"C:\myfile.xml");
         //initiate the  Dataview from the dataset 
         oDataView1 = ds.DefaultViewManager.CreateDataView(ds.Tables(0));
       
         //Lunch the excel
         oExcel = new Excel.Application();
         oExcel.Visible = false;
         oWorkBook = oExcel.Workbooks.Add;
         oWorkSheet = oWorkBook.ActiveSheet;
       
         // Export Datas
         oWorkSheet.Cells(1, 1) = "table from ds";
         i = 2;
         foreach (var dr in oDataView1) {
             oWorkSheet.Cells(i, 1) = dr.Item("columnname");
             i = i + 1;
         }
       
         //Save and close
         oWorkBook.SaveAS(@"C:\myfile.xlsx");
         oWorkBook.Close();

or you have this alternative

http://www.dotnetjohn.com/articles.aspx?articleid=36