Select to view content in your preferred language

Excel to Table Error: Cannot import name multiarray

2447
17
03-07-2018 07:32 AM
JenniferPramuk1
Occasional Contributor

I am trying to convert an Excel table to a .dbf Table, but coming across an error. Before I input the location of the file the error is showing up in the tool. Here is the error message I am getting: 

Does anyone know how to fix this error or know a workaround for this? (I have all the necessary extensions for Arc, so that isn't the problem).

Tags (1)
0 Kudos
17 Replies
JoeBorgione
MVP Emeritus

Seems like a weird error since converting to a table, not an array.  Check the field names in the excel file and make sure that are single words same with the excel file name.

I just used the same tool the other day and it tossed a different error but created the table none the less.

If you can't get ArcGIS to convert it, use excel to convert it to a csv, and bring the csv into ArcGIS and save it as a table.

That should just about do it....
JenniferPramuk1
Occasional Contributor

Well, the odd thing is that I am getting an error before I even attempt to input a table. But the csv options, seems like a good work around for what I need at the moment.

0 Kudos
JoeBorgione
MVP Emeritus

If you do a search on excel along with my name and Dan, you'll see that neither of us are big fans with respect to ArcGIS.  Using excel at one time was a piece of cake; not so much any more!

Dan_Patterson

That should just about do it....
0 Kudos
JenniferPramuk1
Occasional Contributor

For sure. But I think this is an indicator of a larger problem. Turns out I can't use any Tools that require a python multiarry. For example, I can't use Raster Calculator and I can't input any python script into the python window available in ArcMap without the program crashing. Do you know how I could go about solving this python related issue?

0 Kudos
JoeBorgione
MVP Emeritus

My best guess is to follow Dan's suggestion for the repair. If repairing it doesn't do the job, I'd go for a fresh install.  (Ugh...  I know!)

That should just about do it....
0 Kudos
DanPatterson_Retired
MVP Emeritus

Did a repair not work?

The worst that can happen is it doesn't repair anything.

If that doesn't work... go back to the same place, but chose uninstall instead, then clean out any remnants of Arc*anything from you computer before you reinstall.

If you also happen to have other versions of python installed, uninstall those as well.  Arc* behaves much better when it has complete control over its own environment

0 Kudos
JenniferPramuk1
Occasional Contributor

I have already run a repair and uninstalled/re-installed. 

0 Kudos
DanPatterson_Retired
MVP Emeritus

numpy is used in the backend in a number of things.

In short, your python installation is fouled up.  I would suggest going to control panel, add/remove programs and do a 'Repair' on your installation.

Also, if you have installations of python other than that distributed with Arc*, get rid of them unless they are in an anaconda distribution so that their behaviour can be controlled and sheltered from the outside.

JenniferPramuk1
Occasional Contributor

The only python related program I could find on my computer was an Anaconda one. Where else (other than Programs and Features) would I find current installations of python?

0 Kudos