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 }