topic Re: Excel table error message in ArcGIS Pro Questions

Excel table error message

AlysonStanton — Thu, 24 Jun 2021 19:53:31 GMT

I installed the Microsoft Access database engine 2016 - quiet install (determined had click-to-run 64bit) - downloaded the 64bit driver - it appears in Apps & features. Restarted ArcPro 2.8.1. Reconnected folder with excel table - the error message still appears.

Re: Excel table error message

JayantaPoddar — Thu, 24 Jun 2021 19:58:53 GMT

Have you restarted your system after installing the drivers?Install the Microsoft Access Database Engine driver

Re: Excel table error message

AlysonStanton — Thu, 24 Jun 2021 20:02:01 GMT

Yes - restarted - also did a complete shutdown.

Re: Excel table error message

JayantaPoddar — Thu, 24 Jun 2021 20:10:23 GMT

Did you execute the installation process using Command Prompt (Silent Install)?

Here is a nice blog to guide you through the process Guide to connecting to Excel files in ArcGIS Pro

Re: Excel table error message

AlysonStanton — Thu, 24 Jun 2021 23:54:46 GMT

Yes - did a silent (quiet) install using the cmd prompt - it is installed - shows in App&features - but still get error msg.

Re: Excel table error message

JayantaPoddar — Fri, 25 Jun 2021 05:22:11 GMT

Could you share what steps are you following, when you receive the error message?

What is the error message (Share screenshot)?

Re: Excel table error message

AlysonStanton — Fri, 25 Jun 2021 18:11:15 GMT

when I click on an xlsx file - the Error: Required Microsoft driver is not installed appears. When it happened the first time I followed the steps to install the driver (see screen shot). I tried again and the error still appears. PC was shut down - folder was reconnected. I did find that if I saved the file as an xls file the error message did not appear and I was able to geocode the file. However; I find it strange that before upgrading to 2.8.1 I did not have any problems with xlsx files.

Re: Excel table error message

JayantaPoddar — Fri, 25 Jun 2021 18:19:03 GMT

Another workaround could be using Excel to Table.