I have a large Excel spreadsheet that contains lots of numeric data that I would like to import to ArcGIS 10.2 as a table using the Excel To Table (Conversion) tool.
The frustrating thing is that the numeric fields in Excel are repeatedly not recognised and are assumed as being text. I have set the cell format to numeric, cleared any possible blank cells, tried importing as CSV, removed invalid characters in the field headers. yet any possible iota of success evades me.
Does anyone know why this may be happening and/or how it can be resolved?
Answer
Ok so maybe I was too hasty with my angst.
I followed the CSV route found on this page and it worked fine. The frustration is still there however as to why you can't bring in an Excel sheet direct and retain the formatting.
No comments:
Post a Comment