Transfer of data from MS access to excel

Question

Hi i have a small requirement I need to export the data from MS access database to excel File and allow the user to save the excel file in his desired location . Iam writing the code in C#please help me in this regard. Thanks Manoj.

Imtiyaz Ansari · Answer

try this code:- try { string filename1 = Daily Income Report; filename1 = D:\Report\ + filename1 + .xls; Microsoft.Office.Interop.Excel.Application xlApp; Microsoft.Office.Interop.Excel.Workbook xlWorkBook; Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet; object misValue = System.Reflection.Missing.Value; xlApp = new Microsoft.Office.Interop.Excel.ApplicationClass(); xlWorkBook = xlApp.Workbooks.Add(misValue); xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); int i = 0; int j = 0; for (j = 0; j { xlWorkSheet.Cells[1 j + 1] = dataGridView1.Columns[j].Name; } for (i = 0; i { for (j = 0; j { DataGridViewCell cell = dataGridView1[j i]; xlWorkSheet.Cells[i + 2 j + 1] = cell.Value; } } xlWorkBook.SaveAs(filename1 Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal misValue misValue misValue misValue Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive misValue misValue misValue misValue misValue); xlWorkBook.Close(true misValue misValue); xlApp.Quit(); MessageBox.Show(Excel file created  you can find the file); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); return; }

Tulasi · Answer

Hi manoj have a look at the below link http://www.codeproject.com/Questions/537491/5bC-23-5dplusEXPORTplusDATABASEplusMYSQLplusTOplus