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?