nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

New error with Excel To Table

JoeBorgione

ArcGIS Pro 2.4.3

Having just upgraded to the latest patch, I am now seeing something new (for me) when running the Excel to Table tool:

I just X the window and continue; it seems to work just fine...

Kory Kramer‌

Trouver plus de publications taguées avec

Accepted answers

DanPatterson_Retired

If you attempt to access an Excel file in ArcGIS Pro without the appropriate driver installed, you will receive the error Required Microsoft driver is not installed..
To work with Excel files in ArcGIS Pro, you must download and install the Microsoft Access Database Engine 2016 Redistributable from the Microsoft Download Center.

from the help, which you presumably installed?

All comments

GISMallku

Hi Olivia, sorry that you're running into an error. Did you upgrade to 2.5 from 2.4 or an earlier version?

ArcGIS Pro 2.5 is able to use either the 32-bit or 64-bit version of the Access Database Engine driver as described here Work with Microsoft Excel files in ArcGIS Pro—Excel | Documentation The documentation indicates to install the bit-version of the driver that matches your Microsoft products (not the machine). So find out what bit-version of MS Office you're using, then download and install the corresponding Access Database driver from the download center link provided in the ArcGIS Pro help. It is recommended to restart the machine after the installation. Follow the steps provided and circle back if there are any issues.

JoeBorgione

I had to do a complete uninstall and reinstall to get 2.5 loaded up. Tell you the truth, I can't remember what I ended up doing. Kory Kramer‌ has a number of posts on this, and he can provide the definitive answer.

OliviaHarrison

I have also just come across this since upgrading to 2.5

I was previously able to open Excel files, and am now getting this error:

Both my PC and laptop are 64-bit. Do I need to install the 32-bit driver?

JoeBorgione

Haven't yet. But I will...

Done:

For anyone reading this with the same problem: I downloaded the 2016 Redistributable. If you go to the main download page Dan Patterson‌ mentions, do a search the 'access'. Following the instructions Kory Kramer‌ mentioned in his post, I downloaded the 32 bit version and installed it from the command line as discussed here:

DanPatterson_Retired

If you attempt to access an Excel file in ArcGIS Pro without the appropriate driver installed, you will receive the error Required Microsoft driver is not installed..
To work with Excel files in ArcGIS Pro, you must download and install the Microsoft Access Database Engine 2016 Redistributable from the Microsoft Download Center.

from the help, which you presumably installed?

JoeBorgione

Kory- looks like I have the 2007 version:

Just curious if there is documentation from ESRI stating the new one is needed. I've run excel to table dozes of time in past version up to 2.4.0 without an issue.

GISMallku

I doubt this has anything to do with patch 3. See https://community.esri.com/thread/240038-arcgis-pro-exceltosqlite-has-stopped-working-error

It may be related to Access database driver versions... but not sure why you had not seen the issue previously.

DanPatterson_Retired

Joe do a conda list and see what the version number is. This is the version for 2.5 beta 3,

<SPAN class="punctuation token">(</SPAN>arcgispro<SPAN class="operator token">-</SPAN>py3<SPAN class="punctuation token">)</SPAN> C<SPAN class="punctuation token">:</SPAN>\arc_pro\bin\Python\envs\arcgispro<SPAN class="operator token">-</SPAN>py3<SPAN class="operator token">></SPAN>conda list sql
<SPAN class="comment token"># packages in environment at C:\arc_pro\bin\Python\envs\arcgispro-py3:</SPAN>
<SPAN class="comment token">#</SPAN>
sqlite                    <SPAN class="number token">3.29</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="number token">0</SPAN>               he774522_0

<SPAN class="punctuation token">(</SPAN>arcgispro<SPAN class="operator token">-</SPAN>py3<SPAN class="punctuation token">)</SPAN> C<SPAN class="punctuation token">:</SPAN>\arc_pro\bin\Python\envs\arcgispro<SPAN class="operator token">-</SPAN>py3<SPAN class="operator token">></SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.