Failure to import

4087
6
01-31-2015 06:21 PM
WalterWitt
New Contributor III

Arc problem.jpg

Why do I get this message when I try to add a new xls file to an Arc Project?  This problem is a recent development, intermittent but becoming more consistent,

Regards

Walter

0 Kudos
6 Replies
XanderBakker
Esri Esteemed Contributor

What version is your ArcGIS and what version is the Excel file? What is the content of the XLS file? Is it properly structured to be read as table?

0 Kudos
JayantaPoddar
MVP Esteemed Contributor

Hi Walter,

From your snapshot, I believe you are using ArcMap 9.x or earlier.

(Considering your excel sheet is properly structured, as mentioned by Xander) If you are trying to open an XLSX  (*.xlsx) file, it might come up with some error.

Try saving it in XLS (97-2003) format (*.xls), and then opening it in ArcMap.

Thanks,

Jay



Think Location
0 Kudos
WalterWitt
New Contributor III

Thanks Jayanta

I will give it a try and let you know how I get on

Cheers

Walter

0 Kudos
KishorGhatage
Occasional Contributor III

1. Check if there is  any special character in the field name and remove it.

2. Use .xls format

3. Try to save the data in .csv or dbf format and then open it in arcMap.

Kishor

WalterWitt
New Contributor III

Good ideas, mate. That’s the way I am working around it when things get tough, but its not ideal

Regards

Walter

0 Kudos
LoralynClark
New Contributor II

Besides special characters in the field name spaces are a big no-no even on the end of the name. There is also a limit to the number of characters in the field name. Numbers can be used in a field name but not as the first character. Check out http://www.esri.com/news/arcuser/0312/best-practices-when-using-excel-files-with-arcgis.html for more information on using Excel files in ArcGIS.

0 Kudos