[Update 10/30/2017: See the following Microsoft blog post for more information: https://blogs.msdn.microsoft.com/dataaccesstechnologies/2017/10/18/unexpected-error-from-external-database-driver-1-microsoft-jet-database-engine-after-applying-october-security-updates/

Summary: The author offers three approaches to working around the issue: 1) switch to a different import format, 2) uninstall the update, 3) make a registry change to point to an older version of one of the DLL files.  The author also indicates that Microsoft is working on a solution that should be released shortly.]

[Update 10/30/2017: We have confirmed that the “Excel 5.0” format generates the same error as the “Excel 2000” format.]

[Update 10/13/2017: KB4041691 is also an issue on Windows 10.]

A couple of Windows updates began rolling out the evening of 10/10/17.  They are causing the following error when importing into Sage 300 or MISys using the Excel 2000 (.XLS) format: “Unexpected error from external database driver (1)”

One work-around is to save the file as .XLSX and import using the Excel 2007 format. As of this writing, the “official” fix is to uninstall the update.  If the uninstall doesn’t resolve the error on your machine, switching to the Excel 2007 format (or one of the other formats) is the only known remedy.

Please, take care in selecting the update to uninstall.  There is a column for the installation date that may help to confirm you have the correct update.

On Windows 10, the update is KB4041676.

  1. Go to Control Panel
  2. Search for Windows Update
  3. Click on View Installed Updates
  4. Look for KB4041676 and uninstall it
  5. Reboot the workstation and try the import again

On Windows 7, the update is KB4041681.

  1. Go to Control Panel
  2. Search for Windows Update
  3. Click on Windows Update
  4. Click on Installed Updates in the lower left
  5. Look for KB4041681 and uninstall it
  6. Reboot the workstation and try the import again

PHP Code Snippets Powered By : XYZScripts.com
Share This