exporting data from excel sheet to sql server data base

Question

hi how can i export data from excel to sql server database. can any body tell me the procedure how to do this and which is the better way to do this?

kesava reddy · Answer

hi thanks for giving me the sample code but as i am completely new to this .net please send me the code in for loop that how to insert into database;

Sen · Answer

here is a sample code.. using System.Data.OleDb; string sheetName = "Sheet1"; string filePath="C:\temp.xls"; DataTable myDataTable = new System.Data.DataTable(); DataSet dataSet1 = new DataSet(); OleDbDataAdapter oledbAdapterObj; OleDbConnection connection = new OleDbConnection(); OleDbDataAdapter command = new OleDbDataAdapter(); //connection to read excel file connection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;" + "data source='" + filePath + " '; " + "Extended Properties="Excel 8.0;HDR=NO;IMEX=1""); connection.Open(); command = new System.Data.OleDb.OleDbDataAdapter("select * from [" + sheetName + "$]", connection); oledbAdapterObj = command; oledbAdapterObj.Fill(dataSet1); myDataTable = dataSet1.Tables[0]; for (int row = 0; row { for (int col = 0; col { //read data from datatable using // (myDataTable.Rows[row][col].ToString()); } //query to insert to sqlserver database }

exporting data from excel sheet to sql server data base

Answers (2)