You need OLEDB 12 drivers installed on your machine.
Install from this link
http://www.microsoft.com/en-us/download/details.aspx?id=13255[
^]
And the code will be like this .
string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelFileName + ";Extended Properties=\"Excel 12.0;HDR=YES;\"";
OleDbConnection excelConnection = new OleDbConnection(connectionString);
excelConnection.Open();
DataTable dtWorksheetTables = excelConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
if (dtWorksheetTables == null || dtWorksheetTables.Rows.Count == 0) return null;
string worksheetName = GetWorksheetName(dtWorksheetTables);
string strExcelSQL = "SELECT * FROM [" + worksheetName + "]";
OleDbCommand oleDbCommand = new OleDbCommand(strExcelSQL, excelConnection);
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(oleDbCommand);
DataTable excelDataTable = new DataTable();
dataAdapter.Fill(excelDataTable);
dataAdapter.Dispose();
oleDbCommand.Dispose();
excelConnection.Close();
excelConnection.Dispose();
GC.Collect();