Hi all,
When it rains, it pours... now a second issue has arisen - of course when there is a deadline to meet.
I am trying to import an Excel spreadsheet to plot field measurement (geology). I get:
I have tried renaming, saving as .xls, partially recompiling the data in a new spreadsheet, but nothing is working. I had frozen panes and thought this may be a problem when saving the spreadsheet, but have found that it makes no difference. I really need this to work in a hurry, so i anyone can assist I'll be very grateful.
I have attached grabs of the dialogs and an extracts (.xlxs and .xls) from the spreadsheet. The extracts also repeat the issue. For some reason the column order in the Table has changed too, I just noticed! The first two data columns should be to the far right of the last column 'Lineation'.
Thanks in advance.
Can GPS data be downloaded directly into ArcMAP?
How To: Convert Garmin GPS data to feature classes or shapefiles
Find/replace all the spaces to underscores in your field names and you should be good to go.