Select to view content in your preferred language

ArcPro crashing when exporting excel to table

1425
7
08-19-2021 10:46 AM
RandyMcGregor3
Frequent Contributor

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
Frequent Contributor

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
Frequent Contributor

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
Frequent Contributor

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

 

0 Kudos
WilliamKresan
Emerging Contributor

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
Emerging Contributor

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