C#.net Export to Excel from database on button click

Question

Hi I need to export the data from the database to the Excel sheet and vice-versa in windows application. Any help?

Prabhu Raja · Answer

Hi Hope this Will help you http://www.dotnetheaven.com/UploadFile/rahul4_saxena/DataInExcelSheet0530 2007080823AM/DataInExcelSheet.aspx T hank You

Dhaval Patel · Answer

Dear Vijay Please use this Dim cn As ADODB.Connection Dim strSQL As String Dim lngRecsAff As Long Set cn = New ADODB.Connection cn.Open Provider=SQLOLEDB;Data Source= ; & _ Initial Catalog= ;User ID= ;Password=  'Import by using OPENDATASOURCE. strSQL = SELECT * INTO XLImport6 FROM  & _ OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0'  & _ 'Data Source=C:	est\xltest.xls; & _ Extended Properties=Excel 8.0')...[Customers$] Debug.Print strSQL cn.Execute strSQL lngRecsAff adExecuteNoRecords Debug.Print Records affected:  & lngRecsAff 'Import by using OPENROWSET and object name. strSQL = SELECT * INTO XLImport7 FROM  & _ OPENROWSET('Microsoft.Jet.OLEDB.4.0'  & _ 'Excel 8.0;Database=C:	est\xltest.xls'  & _ [Customers$]) Debug.Print strSQL cn.Execute strSQL lngRecsAff adExecuteNoRecords Debug.Print Records affected:  & lngRecsAff 'Import by using OPENROWSET and SELECT query. strSQL = SELECT * INTO XLImport8 FROM  & _ OPENROWSET('Microsoft.Jet.OLEDB.4.0'  & _ 'Excel 8.0;Database=C:	est\xltest.xls'  & _ 'SELECT * FROM [Customers$]') Debug.Print strSQL cn.Execute strSQL lngRecsAff adExecuteNoRecords Debug.Print Records affected:  & lngRecsAff cn.Close Set cn = Nothing http://support.microsoft.com/kb/321686 Thanks & Regards Dhaval Patel This post help you than mark as  Accepted Answer

Faisal Ansari · Answer

Hello Vijay how r u ? dear how did you do this can you provide me your ideas about this ... ?

Vijay Yadav · Answer

I have done Export to Excel from database but now I need to do Import from Excel to database. Any help?