ArcPro crashing when exporting excel to table

1124
7
08-19-2021 10:46 AM
RandyMcGregor3
Occasional Contributor III

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

0 Kudos
7 Replies
JoeBorgione
MVP Emeritus

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

That should just about do it....
RandyMcGregor3
Occasional Contributor III

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.

 

 

 

0 Kudos
RandyMcGregor3
Occasional Contributor III

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.

 

0 Kudos
JoeBorgione
MVP Emeritus

kip-technology.gif

That should just about do it....
RandyMcGregor3
Occasional Contributor III

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

 

0 Kudos
WilliamKresan
New Contributor II

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

0 Kudos
AimeeJones
New Contributor II

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.

0 Kudos