External table is not in expected format

Microsoft odbc driver external table is not in expected format.
What is the root cause of the issue

Connection string used is
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=path
;Extended Properties="Excel 12.0;HDR=YES;
Installed software:
Microsoft office 2013 used (32bit)
Microsoft access database engine 2016
Windows 7 enterprise(32 bit)
Suggest solution

1 answer


maybe you have diffrent types of excell files?

There are diffrent connection strings:

for .xlsx (2007+) is Extended Properties="Excel 12.0 ..."

for .xls (97-2003) is Extended Properties="Excel 8.0 ..."

If this will not help use standard:

Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};