C# พอมีตัวอย่างโค้ดการดึงข้อมูลจาก Excel แล้วบันทึกลงในฐานข้อมูลมั้ยค่ะ

OleDbConnection objConn = new OleDbConnection();
OleDbDataAdapter dtAdapter = default(OleDbDataAdapter);
DataTable dt = new DataTable();

string strConnString = null;
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0; " + "Data Source=" + Server.MapPath("MyXls/MyExcelDB.xls") + ";Extended Properties=Excel 8.0;";
objConn = new OleDbConnection(strConnString);
objConn.Open();

string strSQL = null;
strSQL = "SELECT * FROM [Sheet1$]";

dtAdapter = new OleDbDataAdapter(strSQL, objConn);
dtAdapter.Fill(dt);

//*** BindData To DataGrid ***'
this.myDataGrid.DataSource = dt;
this.myDataGrid.DataBind();

dtAdapter = null;

objConn.Close();
objConn = null;