Export Access table to Excel

Question

Can some assist on how to export mdb or access 2007 datatable to .xls

David Smith · Answer

this is what i have so far, whats is when i click y button , the report goes over to excel with out the data, It only has the headers thats in the report, Im not understanding why . I dont know if its the binding source or not. but its weird. public void Export() { LocalReport lr = new LocalReport(); BindingSource bs = new BindingSource(); DatatabeDataSet test = new CLUDatatabeDataSet OpDatabaseDataSet(); bs.DataSource = test; bs.DataMember = "Datatable"; // the ReportDataSource.Name must be the name of the class that is the DataSource lr.DataSources.Add(new ReportDataSource("CLU_OpDatabaseDataSet_Datatable", bs)); // the ReportEmbeddedResource is the same as what is in the ReportViewer properties lr.ReportEmbeddedResource = "EventLogSam.DatatableReport.rdlc"; string deviceInfo = " " + " false " + " false " + " false " + " "; Warning[] warnings; m_streams = new List (); try { lr.Render("Excel", deviceInfo, CreateStream, out warnings); } catch (Exception ex) { MessageBox.Show(ex.ToString()); return; } foreach (Stream stream in m_streams) stream.Position = 0; } private Stream CreateStream(string name, string fileNameExtension, Encoding encoding, string mimeType, bool willSeek) { Stream stream = new FileStream(sExportPath, FileMode.Create); m_streams.Add(stream); return stream; }

Dipa Ahuja · Answer

http://www.mikesdotnetting.com/Article/79/Import-Data-From-Excel-to-Access-with-ASP.NET http://www.freevbcode.com/ShowCode.Asp?ID=2794

David Smith · Answer

I know that , but how do I get to that object through c# code,

Dipa Ahuja · Answer

In the menus click on external Data and in the export part click on excel If it help you plz mark my answer

Export Access table to Excel

Answers (4)