Unexpected error from external database driver (1)

Xavi Márquez 10/17/17

Since Oct 11 2017, importing data from Excel files generates the following error: "Unexpected error from external database driver (1)".

This is a Microsoft generated problem that is affecting not only Agritec products, but any software that uses XLS files with the Microsoft JET Database Engine. It is a compatibility issue added in a recent Windows update. We have solved the problem using another driver for Excel files called ACE instead of JET. To fix it:

  1. Install Agritec product version 9.3.8 or higher
  2. It may be necessary to install Microsoft Access Database Engine 2010 Redistributable (32 bits)

If you do not have access to this version or you do not want to update, then the workaround is to uninstall the affected Windows updates:

  • KB4041676 -- Windows 10 Version 1703
  • KB4041691 -- Windows 10 Version 1607 and Windows Server 2016
  • KB4041693 -- Windows 8.1 and Windows Server 2012
  • KB4041681 -- Windows 7 and Windows Server 2008 R2

There is additional information at https://social.msdn.microsoft.com/Forums/en-US/2feac7ff-3fbd-4d46-afdc-65341762f753/odbc-excel-driver-stopped-working-with-unexpected-error-from-external-database-driver-1?forum=sqldataaccess