It looks like primary source (in your case Excel) is not getting the commit command to the transaction. But the changes are reflected at InMemory temporary storage. Possible cause could be some unhandled exception during the execution.
As a permanent solution/best practice mode, we can use the below style of coding with TransactionScope for any data source connection/execution.
try
{
conn = new OleDbConnection();
conn.ConnectionString = gm.ConnectionString;
conn.Open();
transaction = conn.BeginTransaction(IsolationLevel.ReadCommitted);
cmd = new OleDbCommand("select * from [ExecutiveMember]", conn);
.................
.................
cmd.ExecuteNonQuery();
transaction.Commit();
conn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
transaction.Rollback();
}