UNIFI fails to export to or import from Excel - WKB15262
SYMPTOMS
- When exporting to Excel from UNIFI, the software reports failure; MS Excel is installed
- Importing from Excel to UNIFI also fails; MS Excel is installed
- Importing Scientific libraries in excel format fails from clients and/or server
ENVIRONMENT
- UNIFI 1.8 Network and workstation
- UNIFI 1.9.2 Network and workstation
- UNIFI 1.9.3 Network and workstation
- UNIFI 1.9.4 Network and workstation
- waters_connect/UNIFI 1.9.12 Network and workstation
- MS Office 365
CAUSE
MS AccessDatabaseEngine.exe (32 bit) is not installed on workstation. This is required to enable Excel import and export. For server installations of UNIFI, the MS access database engine 2010 (32 bit) must be installed on the server.
AccessDatabaseEngine.exe (32 bit) is installed as a prerequisite by the UNIFI installer. However, if the UNIFI installer finds a pre-existing copy of the 64-bit version of AccessDatabaseEngine.exe, installation of the 32-bit version is blocked, and UNIFI import/export from/to Excel won't work.
In addition, it is observed that updating to Microsoft Office 365 may remove the 32-bit version of AccessDatabaseEngine.exe or replace it with the 64-bit version.
Also in some cases the customer IT may remove not understanding that it is an essential part of the UNIFI package.
FIX or WORKAROUND
Server installations:
- If the 64-bit version of MS access database engine 2010 is installed, remove it from the server.
- Install MS access database engine 2010 (32 bit) on the server.
Workstation installations:
- If the 64-bit version of MS access database engine 2010 is installed, remove it using Programs and Features.
- Install MS access database engine 2010 (32 bit), either from the prerequisites folder on the UNIFI installation media or by downloading it from https://www.microsoft.com/en-gb/download/details.aspx?id=13255.
ADDITIONAL INFORMATION
Note that if installing on the server does not help, install the 32-bit version of the MS access database engine 2010 on the UNIFI client(s).
id15262, SUPUNIFI, UNIFISVR, UNIFISW18, UNIFOPT, UNIFQLIC, UNIFSW17, UNIFSW18, UNIFSW19, UNIFWGLIC, UNIFWKLIC