Opening Office 2013 32-bit Excel and Access Files - 2023

MapInfo Pro Release Notes

Product type
Software
Portfolio
Locate
Product family
MapInfo
Product
MapInfo > MapInfo Pro
MapInfo > MapInfo EasyLoader
MapInfo > License Server Utility
MapInfo > MapBasic
MapInfo > MapInfo Pro Advanced
Version
2023
Language
English
Product name
MapInfo Pro
Title
MapInfo Pro Release Notes
First publish date
1985
ft:lastEdition
2023-09-12
ft:lastPublication
2023-09-12T16:43:38.341845

There is a potential issue when both 32-bit and 64-bit versions of MapInfo Pro are installed on the same machine along with the 32-bit version of Microsoft Office 2013. The 32-bit version of MapInfo Pro can close unexpectedly when opening tables generated in the 32-bit version of Excel 2013 or Access 2013.

The section Installing 32-bit and 64-bit Microsoft Office Drivers in the MapInfo Pro Install Guide describes how to install the Microsoft Office 32- and 64-bit drivers on the same system. If after following these steps your 32-bit version of MapInfo Pro closes unexpectedly when opening Excel 2013 and Access 2013 tables, then follow the steps outlined below.

  1. Uninstall both of the Microsoft Access database engine 2016 drivers.
    1. From the Start menu, select Control Panel.
    2. On the Control Panel, select Programs and Features.
    3. Scroll through the list to locate and select Microsoft Access database engine 2016. There will be two instances of this application in the list.
    4. Select Uninstall and follow the instructions that the uninstall procedure provides.
    5. Select the second Microsoft Access database engine 2016 and uninstall it.
  2. Download and install the 32-bit version of Microsoft Access Runtime 2013 (called AccessRuntime_x86_en-us.exe) from https://www.microsoft.com/en-us/download/details.aspx?id=39358.
  3. Download the 64-bit version of Microsoft Access Database Engine 2016 (called AccessDatabaseEngine_x64.exe) from https://www.microsoft.com/en-us/download/details.aspx?id=54920. Make note of the download location, such as C:\Users\myname\Downloads.
    CAUTION:
    Do not run (install) from your internet browser window, download it first.
  4. Install the 64-bit version of Microsoft Access Database Engine 2016 (called AccessDatabaseEngine_x64.exe).
    1. Open a command prompt window with Administrator privileges. In the system folder C:\Windows\System32, right-click on cmd.exe and select Run as Administrator.
    2. At the command prompt, change directories to the AccessDatabaseEngine_x64.exe file (type cd C:\Users\myname\Downloads and press Enter).
    3. At the command prompt, type AccessDatabaseEngine_x64.exe /quiet /norestart and press Enter.
  5. If you have a 32-bit version of Microsoft Office 2007, 2010, 2013, or 2016 installed, then delete or rename its mso.dll registry key.
    1. Open the Registry Editor window. On the Microsoft Start menu, type regedit in the Search field, and then click regedit.exe.
    2. In the Registry Editor window, navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Common\FilesPaths.
    3. If there is a mso.dll value, either delete it or rename it.
      If you do not delete or rename the file, then may see a reconfigure message when you open a Microsoft Office application.

Both 32-bit and 64-bit drivers are now installed on your system, and you can open Access 2013 and Excel 2013 files in both 32-bit and 64-bit versions of MapInfo Pro.