topic Re: Conflict w/2007 Office System Driver and Access 2016 in Developers Questions

Conflict w/2007 Office System Driver and Access 2016

GregTurner1 — Wed, 08 Nov 2017 16:45:23 GMT

Anyone seen this one? 2007 Office System Driver seemed to be fine until we hit Office 2016. Seeing little to nothing useful through Google or perusing the community so far.

Windows 2012 R2

ArcGIS 10.2.1 UTUP5

ArcFM 10.2.1

1) Issue adding XLSX files through Add Data. No issues reported with other file types.
2) Install ESRI recommended 2007 Office System Driver.
3) XLSX problem solved.
4) Now Access 2016 doesn't work...allow Access 2016 to configure itself.
5) Access 2016 works...XLSX problem now back -- along with a SEEMINGLY new issue of an error "Failed to connect to database. General function failure. Unexpected error from external database driver (1)." when loading an XLS (not XLSX) file.

Re: Conflict w/2007 Office System Driver and Access 2016

ShawnMacDonald1 — Tue, 17 Sep 2019 19:31:38 GMT

Hi Greg,

We're running into this exact issue as well. I was hoping it would be resolved at 10.6.1 but nope. Switching from MS Office 2016 to adding a xlsx file to ArcMap requires installing that 2007 driver. Very annoying and would be even more annoying if I didn't have local admin rights on my machine to install software.

Have you found a better solution to this since posting the above?

Re: Conflict w/2007 Office System Driver and Access 2016

LanceCole — Tue, 17 Sep 2019 21:06:42 GMT

The 2007 driver has been depreciated, you need to install the Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download Center to work with Excel and Access. It is needed for interoperability between Office applications and third party application such as ArcGIS. Your IT department can include this as part of their MS Office deployment based upon group policy for GIS users automatically.

Additional info on the needed driver is available at Understanding how to use Microsoft Excel files in ArcGIS—Help | ArcGIS Desktop

Re: Conflict w/2007 Office System Driver and Access 2016

KoryKramer — Tue, 17 Sep 2019 21:10:16 GMT

Desktop doc: Understanding how to use Microsoft Excel files in ArcGIS—Help | ArcGIS Desktop