I'm receiving Excel .xlsx files from a customer that (according to the file properties) is using Kendo UI to generated these files.
These Excel files fail to import to my database using 'Microsoft Excel ODBC driver' version 15.00.4543.1 dated 23/01/2014.
Error message: [Microsoft][ODBC Excel Driver] External table is not in the expected format.
I've done a lot of internet searching with no successful work around.
Has anyone else had this issue?
The files open OK in Excel and if I save the unchanged file, the ODBC issue does not occur.
I'm running Office 2016 + 'MS Access Runtime 2013' (unable to install Runtime 2016 with a clash with Office / Microsoft website reports version 2013 and 2016 are near identical).
Any suggestions are appreciated.