C#

Framework Version: v4.0.30319
Description: The process was terminated due to an internal error in the .NET Runtime at IP 6B50927D (6B290000) with exit code 80131506.

DataTable dtTempTable = new DataTable();
DataTable dtMyTable = new DataTable();
DataRow drMyRow;
int nRowCount = 0;

nRowCount = 0;

strSCell[0] = "A";
strSCell[1] = "1";
strECell[0] = "IV";
strECell[1] = "65536";

if (CommonLib.IsNullString(FileName.Substring(FileName.Length - 4, 4)).Equals("xlsx"))
{
    // strProvider = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + (FilePath + FileName) + ";Extended Properties=Excel 12.0;IMEX=1;HDR=Yes;";

    strProvider = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=";
    strProvider += (FilePath + FileName);
    strProvider += @";Extended Properties=""Excel 12.0;Imex=1;HDR=YES;""";

    strQuery = "Select * From [Sheet1$" + strSCell[0] + strSCell[1] + ":" + strECell[0] + strECell[1] + "]";
}
else
{
    // strProvider = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + (FilePath + FileName) + ";Extended Properties=Excel 8.0;IMEX=1;HDR=Yes;";

    strProvider = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
    strProvider += (FilePath + FileName);
    strProvider += @";Extended Properties=""Excel 8.0;Imex=1;HDR=YES;""";

    strQuery = "Select * From [Sheet1$" + strSCell[0] + strSCell[1] + ":" + strECell[0] + strECell[1] + "]";
}

OLEDBConnection = new OleDbConnection(strProvider);
OLECommandObject = new OleDbCommand(strQuery, OLEDBConnection);
OLEDBConnection.Open();

if (OLEReader != null)
{
    if (!OLEReader.IsClosed)
        OLEReader.Close();
}

OLEReader = OLECommandObject.ExecuteReader(CommandBehavior.CloseConnection);
dtTempTable.Load(OLEReader);

if (dtTempTable.Rows.Count > 0)
{
    dtMyTable = dtTempTable.Copy();
}

if (OLEReader != null)
{
    if (!OLEReader.IsClosed)
        OLEReader.Close();
    OLEReader.Dispose();
}

if (OLEDBConnection != null)
    OLEDBConnection.Close();

return dtMyTable;