Try this
i got the same error long back, i used the below snippet to resolve it. :)
if (version == "xlsx")
SourceConstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + path + "'; Extended Properties= 'Excel 12.0;HDR=Yes;IMEX=1'";
else
SourceConstr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + path + "; Extended Properties=Excel 8.0;";