So here’s a weird quirk – if I repeat the above import, the ODBC error message changes to:ODBC Excel Driver General error unable to open registry key temporary (volatile) ace DSN
Even after I restart my computer and try a copy of the import file, this same error occurs.
If I re-install SQLyog (version 12.2.6 current version), the error revert back ‘External table is not in the expected format’ and another import reverts to error ‘open registry key temporary (volatile) ace DSN’.
Odd….
The source Excel file is attached for any willing helpers.
Thanks
Chris