how to import excel data tosql

Question

how to import an Excel file into Sql C# code windows

Abhishek Jaiswal · Answer

Hey! You can use any of these approaches SQL Insert Task based on SSIS SQL bulk query operations SQL Server configuration manager Import & Export option Using conversion codes at client side For Further details go through my article http://www.c-sharpcorner.com/UploadFile/2072a9/import-data-from-excel-to-sql-server-ssis/ : )

Rahul Bansal · Answer

You can also do this like //------------------------------------- string strConn = ; switch (Path.GetExtension(openFileDialog.FileName)) { case .xls: //Excel 1997-2003 strConn = Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + openFileDialog.FileName + ;Extended Properties=\Excel 8.0;HDR=Yes;IMEX=1\; break; case .xlsx: //Excel 2007-2010 strConn = Provider=Microsoft.ACE.OLEDB.12.0;Data Source= + openFileDialog.FileName + ;Extended Properties=\Excel 12.0 xml;HDR=Yes;IMEX=1\; break; } //Get the data from the excel sheet1 which is default string query = select * from [Sheet1$]; // Add System.Data.OleDb; OleDbConnection objConn; OleDbDataAdapter oleDA; DataTable dt = new DataTable(); objConn = new OleDbConnection(strConn); objConn.Open(); oleDA = new OleDbDataAdapter(query objConn); oleDA.Fill(dt); objConn.Close(); oleDA.Dispose(); objConn.Dispose(); //Save the dt value in to the database //------------------------------------