How to read large excel file in step by step limited records in C# ?

See more:

C#4.0

I have a 3,00,000 records Excel file, so I want to import records by 30,000 in each process. How to do that in C#?

I have used the OLEDB connection jet provider to import records but it imports records in one go in Datatable and sometimes causes error: out of memory to process Exception

What I have tried:

string Excel03ConString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel 8.0;HDR=YES'";
string Excel07ConString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 8.0;HDR=YES'";

string conStr, sheetName;
conStr = string.Empty;

switch (extension)
{
    case ".xls": //Excel 97-03
        conStr = string.Format(Excel03ConString, fileName);
        break;
    case ".xlsx": //Excel 07
        conStr = string.Format(Excel07ConString, fileName);
        break;
}

//Get the name of the First Sheet.
using (OleDbConnection con = new OleDbConnection(conStr))
{
    using (OleDbCommand cmd = new OleDbCommand())
    {
        cmd.Connection = con;
        con.Open();
        DataTable dtExcelSchema = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
        sheetName = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString();
        con.Close();
    }
}

//Read Data from the First Sheet.
using (OleDbConnection con = new OleDbConnection(conStr))
{
    using (OleDbCommand cmd = new OleDbCommand())
    {
        using (OleDbDataAdapter oda = new OleDbDataAdapter())
        {
            cmd.CommandText = "SELECT * From [" + sheetName + "]";
            cmd.Connection = con;
            con.Open();
            oda.SelectCommand = cmd;
            //dt.Locale = CultureInfo.CurrentCulture;
            oda.Fill(dt);
            con.Close();
        }
    }
}