How to export data table to excel in C# using oledb?

See more:

ASP.NET

C#3.5

MS-Excel

OleDb

How to export data table to excel in c# using Oledb?
I want to transfer data in data table to excel in c# using Oledb provider. I am able to insert few cells using below code:

try
            {
                string filelocation = @"E:\Alex\Arab_Test_Oledb.xls";
                System.Data.OleDb.OleDbConnection MyConnection;
                System.Data.OleDb.OleDbCommand myCommand = new System.Data.OleDb.OleDbCommand();
                string sql = null;
                //string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filelocation + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";
                MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filelocation + ";Extended Properties=Excel 8.0;");

                MyConnection.Open();

                myCommand.Connection = MyConnection;

                sql = "Insert into [Sheet1$] (EMPLOYEE_ID,ADDRESS1) values('5','e')";

                myCommand.CommandText = sql;

                myCommand.ExecuteNonQuery();

                MyConnection.Close();

            }
            catch (Exception ex)
            {
                
            }

What I have tried:

My code is as below:
try
{
string filelocation = @"E:\Alex\Arab_Test_Oledb.xls";
System.Data.OleDb.OleDbConnection MyConnection;
System.Data.OleDb.OleDbCommand myCommand = new System.Data.OleDb.OleDbCommand();
string sql = null;
//string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filelocation + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";
MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filelocation + ";Extended Properties=Excel 8.0;");

MyConnection.Open();

myCommand.Connection = MyConnection;

sql = "Insert into [Sheet1$] (EMPLOYEE_ID,ADDRESS1) values('5','e')";

myCommand.CommandText = sql;

myCommand.ExecuteNonQuery();

MyConnection.Close();

}
catch (Exception ex)
{

}