- For example, KB4048953 resolves the issue for Windows 10, build 14393.1884:
Addressed issue where applications based on the Microsoft JET Database Engine (Microsoft Access 2007 and older or non-Microsoft applications) fail when creating or opening Microsoft Excel .xls files. The error message is: “Unexpected error from external database driver (1). (Microsoft JET Database Engine)".
Affected updates that may cause this issue include (but are not limited to):
- Windows 7/Windows Server 2008 R2 security updates KB4041681 & KB4041678
- Window 8.1/Windows Server 2012 R2 security update KB4041693
- Windows 10 security update KB4041676 & KB4041691 . *There have been instances of neither of the two security updates being installed, in that case, removing KB4043961 resolves the issue.
Until Microsoft releases a fix for your build, it's possible to uninstall these Windows updates from any affected workstations:
- Go to Start > Control Panel
- Under Programs click Uninstall a program
- Click View installed updates on the left side of the window.
- This displays all updates installed on the system.
- Locate the update(s), right-click it and select uninstall from the menu.
- This removes the update from the system.
- Reboot the workstation.
- Go to File > Export
- Select the Comma Separate Values (CSV) format
- Open the Export file.
- Select Tools > Export Options from top menu bar
- Select Export format field
- From drop down menu select Comma Separated Values (CSV).
- Click OK.
- You can now open the CSV file you created in Excel and re-save it as an Excel file type.
- To export from Batch, open the batch
- Right click within the batch and select Export Batch Grid
- Select export format field
- from drop down menu select Comma Separated Values (CSV)
- Click OK.
- You can now open the CSV file you created in Excel and re-save it as an Excel file type