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;
read-only=0;";"
Installed software:
Microsoft office 2013 used (32bit)
Microsoft access database engine 2016
Windows 7 enterprise(32 bit)
Suggest solution

0
edit delete
are you sure?
asked Anonymous user

1 answer

Hello,

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)};
DBQ=file.xls;

0
edit delete
are you sure?
answered Krysztof Spaliński

Post an answer but please log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

    Forumall questions