topic Re: Table to Excel not ending properly in ArcGIS Pro Questions

Table to Excel not ending properly

LéonRastoul — Sun, 26 Jun 2022 13:37:39 GMT

I just switched to ArcGIS Pro 3.0 and encountered a problem with the Table to Excel function.

When executing the function, it does write the output file (.xlm) successfully, but the process in ArcGIS doesn't stop. This is preventing me from starting any other function. Cancelling the "Table to Excel" isn't really an option, as the cancelling process also takes an infinite amount of time. There is a process in the task manager "ExceltoSQLite64" which has a high CPU usage.

Is there a way to fix this ?

Edit: I've included a Test File in case anyone wants to try with the same file.

Thanks.

Re: Table to Excel not ending properly

JayantaPoddar — Sun, 26 Jun 2022 10:38:31 GMT

What is the output file path? Could you restart ArcGIS Pro and try again?

My ArcGIS Pro is at 2.9.2. Haven't upgraded yet. The tool works fine for me.

Re: Table to Excel not ending properly

LéonRastoul — Sun, 26 Jun 2022 11:04:50 GMT

It worked fine in the previous version for me as well.

The path is unchanged since the upgrade to 3.0 "C:\Users\X\ModelOutputs\Test.xls". I've also tried to save as an .xlsx.

The only way for me to effectively cancel the Table to Excel process is to restart ArcGIS Pro, so yes, I did multiple times.

If it worked in the previous version, is there a way to go back to it ?

Re: Table to Excel not ending properly

feralcatcolonist_old — Sun, 26 Jun 2022 13:04:02 GMT

Also confirming here on 3.0, Table to Excel does not work for either xslx or xls on a standard user profile drive; also in a canceling loop which could not be undone even by trying to close the program, it had to be force quit via task manager. Also saw the same thing with 20% cpu usage by Pro's ExcelToSQLite64 subprocess.

The excel files write almost immediately and are usable afterwards.

This previously worked for me pre-3.0.

Re: Table to Excel not ending properly

LéonRastoul — Sun, 26 Jun 2022 13:26:26 GMT

Hi, there is a workaround.

Exporting the Attribute Table as a .dbf and then dragging the .dbf into an empty Excel Workbook does the trick.

I hope it helps.

Re: Table to Excel not ending properly

Region_VII_PDC — Tue, 28 Jun 2022 13:23:54 GMT

I am having the same issues with the Table To Excel geoprocessing tool. The tool creates the designated Excel file (xlsx format) but the tool within in ArcGIS Pro 3.0 continues to show processing. Canceling the tool process does not resolve the issue.

Re: Table to Excel not ending properly

DirkThuynsma — Wed, 29 Jun 2022 15:23:18 GMT

Same problem

Re: Table to Excel not ending properly

BarryNorthey — Wed, 29 Jun 2022 17:02:01 GMT

I had no problems creating xls or xlsx files using your data in ArcGIS Pro 3, so not much help other than it does work in some circumstances. Both Excel products were created in about 6 seconds. I ran the script on my own shapefiles without problems.

I did notice that just adding your shapefile to a Map threw lock files visible in File Explorer, which is unusual since no processes were attached and I cleared any related geoprocessing history. It doesn't happen with my own shapefiles. No idea why.

Re: Table to Excel not ending properly

MichaelTimmerman — Thu, 30 Jun 2022 21:04:38 GMT

Same problem

Re: Table to Excel not ending properly

RhettZufelt — Thu, 30 Jun 2022 21:17:00 GMT

Not sure if this would apply, but I had similar issues on a computer with a newer version of office installed (office 365).

Once I got the right drivers installed (Microsoft Access Database Engine 2016) (see here), the excel issues went away. (Had to do the silent install)

Re: Table to Excel not ending properly

CaiShu — Mon, 04 Jul 2022 12:52:23 GMT

Same problem

Re: Table to Excel not ending properly

PatriciaKJ — Wed, 13 Jul 2022 18:50:30 GMT

Me, too. There's some vague text that says that you need to have the Microsoft access driver and the .Net SDK loaded before installation; I uninstalled, verified everything was in place, and re-installed. Still doesn't work.

Re: Table to Excel not ending properly

RhettZufelt — Wed, 13 Jul 2022 20:16:11 GMT

To install Pro 3, you need the .NET Desktop Runtime 64 bit. NOT the .NET Runtime, but the Desktop Runtime 64 bit.

You also need the Microsoft Access Database Engine 2016 Redistributable 64-bit driver to access the Excel files. However, if you already have the Microsoft Access Database Engine 2016 Redistributable 32-bit driver installed, you will also need the 32-bit .NET Desktop Runtime as well.

So, if you have both Pro and Map installed, you will need to install both 32-bit and 64-bit version of BOTH the .NET Desktop Runtime, and the MS Access DB Engine 2016 Redistrubutable.

Re: Table to Excel not ending properly

PatriciaKJ — Wed, 13 Jul 2022 22:17:17 GMT

RhettZufelt - Thank you so much! I think I'm back in business. Your post was exactly what I needed at exactly the right time.

The steps I then took:

I removed existing Microsoft utilities, reinstalled them and confirmed an install of the Net Desktop Runtime 64 bit. See https://www.microsoft.com/en-us/download/details.aspx?id=54920

I also removed my existing 3.0 install and then installed it again. I re-used an existing install download package.

An initial test run of a small file was slow but functional.

Yay! now I can get back to work.

Thx, pkj

Re: Table to Excel not ending properly

feralcatcolonist_old — Tue, 26 Jul 2022 23:51:43 GMT

For me it was just the Microsoft Access driver being out of date, Esri released a technical article for it.

https://support.esri.com/en/technical-article/000027949

Re: Table to Excel not ending properly

Orca654 — Fri, 26 Aug 2022 17:25:42 GMT

You cannot install 32-bit and 64-bit MS Access DB Engine 2016 Redistributable together on the same machine! That actually depends on o your Office version. If you have 64-bit Office, you only can install the 64-bit MS Access DB Engine 2016 Redistributable.

BTW, if you installed any updates from ESRI for now, say ArcGIS Pro 3.0.1, you will need to reinstall or "fix" MS Access DB Engine 2016 Redistributable again! Otherwise, the crash/Freeze will come up again.

Re: Table to Excel not ending properly

Orca654 — Fri, 26 Aug 2022 17:29:54 GMT

Same Issues while using the "Excel to Table" or "XY Table to Point" to load an Excel file. Following the instructions above to install the MS Access DB Engine 2016 Redistributable will solve the issues.

And I also tested that ArcGIS Pro 3.0.1 didn't fix this issue!

Re: Table to Excel not ending properly

RhettZufelt — Fri, 26 Aug 2022 18:17:53 GMT

Not only can you install the 32-bit and 64-bit version of the MS Access DB Engine 2016 Redistributable together on the same machine, if you have both Pro and Desktop installed on that machine, you will most likely never get past these Excel issues until you do.

Depending on your Office version, you may need to do a silent install.

Re: Table to Excel not ending properly

LukeGilner1 — Wed, 31 Aug 2022 20:19:02 GMT

Same problem after upgrading to 3.0. I found the information to download .NET Desktop and the MS Access DB Engine a while back, but it still wasn't working. Now, after reading through this post I tried the silent install on the DB Engine and that did the trick! Thanks!

Re: Table to Excel not ending properly

GrahamWashburn — Thu, 01 Sep 2022 15:13:11 GMT

There is a bug logged related to this. I have the same problem and was recently on a zoom call with support about it. Do you have ArcMap installed on the same machine? Support told me that may be contributing to the issue.

Link to the related bug page is below 🙂

BUG-000150929: This is a reoccurring issue. ArcGIS Pro loads indefi.. (esri.com)