Read Excel File Through SQL Commands SELECT / INSERT / UPDATE in C#

// Posted By Suresh Chand Jangid
string strConn = "Provider=Microsoft.Jet.OleDb.4.0;data source=c:/NameAndAddress.xls;Extended Properties=Excel 8.0";
OleDbConnection objConn = new OleDbConnection(strConn);
string strSql = "Select LastName, FirstName, Address, City, State From [Sheet1$]";
lblSql1.Text = strSql;
OleDbCommand objCmd = new OleDbCommand(strSql, objConn);
objConn.Open();
dtgAddresses1.DataSource = objCmd.ExecuteReader();
dtgAddresses1.DataBind();
objConn.Dispose();
objConn = new OleDbConnection(strConn);
strSql = "Select * From [Sheet1$] Where State='CA'";
lblSql2.Text = strSql;
objCmd = new OleDbCommand(strSql, objConn);
objConn.Open();
dtgAddresses2.DataSource = objCmd.ExecuteReader();
dtgAddresses2.DataBind();
objConn.Dispose();
objConn = new OleDbConnection(strConn);
strSql = "UPDATE [Sheet1$] SET LastName='CHAND' where FirstName='Suresh'";
objCmd = new OleDbCommand(strSql, objConn);
objConn.Open();
objCmd.ExecuteNonQuery();
objConn.Dispose();
objConn = new OleDbConnection(strConn);
strSql = "INSERT INTO [Sheet1$] (LastName, FirstName, Address, City, State) VALUES ('a','b','c','d','e')";
objCmd = new OleDbCommand(strSql, objConn);
objConn.Open();
objCmd.ExecuteNonQuery();
objConn.Dispose();