You need to tell the provider that you are using Excel 97-2003 (xls unlike xlsx), adding:
Extended Properties="Excel 8.0"
eg.
string ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\"Book1.xls\";Extended Properties=\"Excel 8.0\"";
source
share