topic Re: importing excel file issue in Data Management Questions

importing excel file issue

francescarusso — Thu, 12 Oct 2017 15:47:30 GMT

Hi all,

I am struggling with something I have being doing many many times before.

I want to import an excel file with some coordinates In ArcGIS 10.2.2 but when I try to import it (either via the "Add in" button and via drag and drop) I get a strange error message (please see screenshot below).

I have tried to import also some old excel sheets that have previously worked but I have the same message.Also the icons on the top right look not active for some reason (pale grey- see the red circle)

Any suggestions?

Many thanks

Re: importing excel file issue

DanPatterson_Retired — Thu, 12 Oct 2017 23:25:04 GMT

didn't the Excel to Table tool exist in 10.2.2? it did in 10.3 and that tool handles a lot of stuff that can't be handled by shortcuts like trying to add it directly

Re: importing excel file issue

JayantaPoddar — Fri, 13 Oct 2017 03:59:36 GMT

Another option could be installing Download 2007 Office System Driver: Data Connectivity Components from Official Microsoft Download Center

Re: importing excel file issue

francescarusso — Fri, 13 Oct 2017 08:03:35 GMT

Hi Dan,

many thanks for your reply. Actually the conversion from excel to table did work.

To me it looks still a bit odd I was not able to import my excel sheet via "Add Data" tool as I have always done that.

To be honest normally I import quite big excel sheet (I mean many rows and columns) and I have never had this issue. This time was just about 10 values, so really I do not know what did happen. It looks like suddenly some tools are not active anymore. Is it possible it is due to some windows updates? My computer run some updates in the last few days...

Many thanks indeed as my job is done anyway but if I could understand what happened it would be great.

Have a nice day

Re: importing excel file issue

DanPatterson_Retired — Fri, 13 Oct 2017 08:09:36 GMT

Francesca... It sounds like the workaround patch may be the issue... but I still recommend using the Excel to Table and Table to Excel tools provided on esri, which actually is more aware of the needs of the conversions, rather than rely on an operating system change... especially when you consider that you have not control at some level as to what changes it will make. The couple of extra clicks is worth the comfort in knowing that more effort has gone into making a better more reliable conversion.

Re: importing excel file issue

AmyGwin2 — Tue, 02 Apr 2019 22:21:12 GMT

Your solution fixed my problem two yeas ago. However, my coworker is having the same error. I believe he needs that driver as well. Do you have any idea where to download it? Microsoft has moved it.