Make use of OLEDB connection.
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";
or plz check the belwo code
public static DataTable ReadExcel(string path)
{
DataTable dTable = new DataTable();
try
{
if (!File.Exists(path))
return null;
string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0;";
string query = "SELECT * FROM [Sheet1$]" ;
OleDbDataAdapter dAdapter = new OleDbDataAdapter(query, connString);
dAdapter.Fill(dTable);
dAdapter.Dispose();
}
catch (Exception e)
{
Console.WriteLine(e);
}
return dTable;
}