I am trying to convert an excel table into a shapefile. I use the Add XY Data which seems to work fine, but when I import into a geodatabase it crashes. If I try to just use "export data" from the XY data, it doesn't crash, it just produces an empty shape file (though the fields have the correct names).
I've filled all empty cells in the excel sheet, removed all of the unusable characters, and everything else I can think of and its still crashing. Whats really frustrating is that had no problems doing this with a table that had plenty of blank cells and unusable characters.
So any ideas?
Solved! Go to Solution.
Ok it looks like the problem was that I had a field called Shape. I renamed that and it works now.
Thanks for your help.
Hello,
When you perform XY Data by adding the X and Y values., do the points overlay correctly to you area of Interest? try zooming to a point. If so, then have you exported the data just in a shapefile.shp. (I want to be clear but I believe you stated above that it shows the attribute name by no data).
Can you send me a sample of your excel spreadsheet?
Thanks
James
The points do plot correctly when I do the Add XY, but when I export the data it gives me a blank table. If its a shapefile as soon as I do Add XY then I'm sorry, I'm just getting the terminology screwed up. What I want is for the data to be selectable, and able to put it into a geodatabase.
Here is part of the spreadsheet.
Vol | X | Y | Max_depth | Min_Depth | Top | Timing | Shape |
3 | 517322 | 982208 | 3750 | 1886 | 2590 | Rift | Dome |
4 | 508875 | 990332 | 4350 | 1350 | 2390 | Rift | Dome |
5 | 523222 | 987760 | 3400 | 1550 | 2850 | Rift | Buldge |
6 | 522910 | 989792 | 3252 | 1780 | 2850 | Rift | Bright_spot |
7 | 516288 | 985887 | 4200 | 2700 | 3029 | Rift | Pock_mark |
8 | 513708 | 984670 | 4190 | 1200 | 2890 | Rift | Dome |
9 | 500980 | 985700 | 3350 | 850 | 1300 | Post_Rift | Cone |
10 | 503602 | 985588 | 3700 | 2350 | 2600 | Rift | Dome |
11 | 509213 | 979408 | -9999 | -9999 | -9999 | Post_Rift | Cone |
12 | 517674 | 987473 | 3850 | 1600 | 2650 | Rift | Dome |
Ok it looks like the problem was that I had a field called Shape. I renamed that and it works now.
Thanks for your help.
Great Clinton!
Hey Clinton,
Could you mark this post as correct?
Thanks