Error: Error in working with excel files in LOGIC: External table is not in the expected format OR The file is not an valid Package file. If the file is encrypted, please supply the password in the constructor.

When working with excel files in LOGIC you may get following errors. These errors usually comes after you install windows update on or after 11th Oct 2017.
if you get any of the following errors while exporting/importing using excel files then go through the resolution provided.


The file is not an valid Package file. If the file is encrypted, please supply the password in the constructor.
OR
Unexpected error from external database driver (1). (Microsoft JET Database Engine)

Resolution


The issue has been found to be due to issues with the following Windows updates:
  • 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

Uninstall these Windows updates from any affected workstations:
  1. Go to Start > Control Panel
  2. Under Programs click Uninstall a program
  3. Click View installed updates on the left side of the window.
  4. This displays all updates installed on the system.
  5. Locate the update(s) (KB4041681 & KB4041678 for Windows 7/Windows Server 2008 R2, KB4041693 for Window 8.1/Windows Server 2012 R2, or KB4041676 for Windows 10), right-click it and select uninstall from the menu.
  6. This removes it from the update from the system.
  7. Reboot the workstation.