topic Re: ArcPro crashing when exporting excel to table in ArcGIS Pro Questions

ArcPro crashing when exporting excel to table

RandyMcGregor3 — Thu, 19 Aug 2021 17:46:02 GMT

I have a python script that works fine, but lately is crashing on the following line:

arcpy.conversion.ExcelToTable(ef,out_tab)

I can run excel to table fine from the map but it crashes in the python script.

Completely shuts down the arcgis pro document.

Is there some known issue with ArcPro and this command in arcpy?

Thank you,

Randy

Re: ArcPro crashing when exporting excel to table

JoeBorgione — Thu, 19 Aug 2021 17:51:27 GMT

Does it work as a stand alone script run from a python console?

Re: ArcPro crashing when exporting excel to table

RandyMcGregor3 — Thu, 19 Aug 2021 18:07:34 GMT

Thank you. Good question. The answer is, 'no' It does not. Instant Arcpro crash. I ran it as a geoprocessing tool and it went fine. I copied the history as a python script and pasted it in and ran from the console.

Re: ArcPro crashing when exporting excel to table

RandyMcGregor3 — Thu, 19 Aug 2021 18:18:50 GMT

I spoke to soon - It does not crash when run from the python window within arcpro. It seems to have once, but is working now.

Re: ArcPro crashing when exporting excel to table

JoeBorgione — Thu, 19 Aug 2021 18:31:19 GMT

Re: ArcPro crashing when exporting excel to table

RandyMcGregor3 — Thu, 19 Aug 2021 18:33:57 GMT

Ugh. It's working now. This problem comes and goes and it's gone (for now).

Re: ArcPro crashing when exporting excel to table

WilliamKresan — Fri, 16 Sep 2022 15:32:55 GMT

I've been running into this for near a month now. The Geoproccessing tool crashes, the Notebook crashes, the Python Window crashes.

It will generate the excel file for me, however, I have to Task Manager out of Pro each time.

Any possible update with known bugs with this tool? Currently in 3.0

Re: ArcPro crashing when exporting excel to table

AimeeJones — Mon, 19 Sep 2022 18:44:49 GMT

There's some new x64 and x86 driver updates and an Access Database 2016 driver database that fixed mine temporarily. It seems to have issues again after only 3 weeks.