Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have added a table from Access to ArcMap, and then used 'Display XY data' to plot points. When I then try to export the Events to a shapefile I get an error message telling me:

"Error exporting data. Create output feature class failed"

Followed by:

"Warning: Some records may not have been exported correctly."

and then:

"There was an error exporting the layer."

Can anyone tell me why this is happening, and how I can export my data?

I was able to export an almost identical file this morning with no problems. I'm saving straight to my C drive, so no unusual characters in the files path. All the fields are either text or Long types, and none have long names/unusual characters in their names.

I've tried restarting ArcMap and my machine, and exporting to several different locations.

I'm using version 10, with Access 2007, and there are 7332 points in the table.

Thanks,

Flo

share|improve this question
2  
there are some 'null' records in your event layer (from access). –  Mapperz Sep 10 '12 at 15:34
    
Some records have null values for some fields, but none are completely null –  Flo Harrison Sep 10 '12 at 15:36
5  
Coordinate fields must not be null. Even one blank record will cause this error. Unexpected value may also cause this error. Ensure both X and Y coordinates have consistent numeric values. –  Jakub Sep 10 '12 at 16:04
    
Jakub is correct if any 'null' records exist the export will fail. –  Mapperz Sep 10 '12 at 17:48
add comment

5 Answers

My guess is that you may have blank spaces in your column headings. Try replacing them with an underscore

share|improve this answer
    
I don't have any spaces in my field headings. I was able to export an almost identical file this morning - it had the same field headings and number of records. –  Flo Harrison Sep 10 '12 at 15:48
4  
Does ArcMap let you save it as a DBF file without any problems? Try this: blogs.esri.com/esri/supportcenter/2012/05/24/… –  Rayner Sep 10 '12 at 15:55
add comment

I had this exact same problem today. It wasn't permissions, it was weird characters in my data. As it turned out, I had pound signs (#) in the labels column and when I got rid of those, the shapefile export worked perfectly.

share|improve this answer
    
+1 Thank you for sharing your experience--it may help others. Welcome to our site! –  whuber Nov 6 '12 at 22:42
add comment
  1. If you zoom to the extent of your xy data,
  2. Then select the window so you only get the records you want.
    (any way you can get that selection is acceptable).
  3. Ensure that the mxd projection is set to the projection you want to output.
  4. Then export the data from the table of contents (not the attribute table).
  5. Make sure that you use the selected features and the data frame for theprojection.
share|improve this answer
add comment
up vote 1 down vote accepted

Apologies for answering my own question, and for making a bit of a silly mistake, really.

I've found that my problem was caused by trying to export the data to a location I didn't have permission to save to.

The error message in ArcMap obviously didn't help uncover that issue - it came to light when I tried to export to a dbf from my Access database.

Thank you for all the other suggestions.

share|improve this answer
    
I was going to suggest it was a permissions issue, but figured it wasn't the case since you said you tried "exporting to several different locations." You should mark this as the accepted answer, so that it can help others who may have the same question in the future. –  user3461 Sep 11 '12 at 11:14
1  
Yes, I think my initial attempts to export were to somewhere I should have been able to save to, so I'm not sure what the problem was then (possibly a conflict with the file name as I had previously exported and deleted the file, and I've found that does sometimes cause issues). After restarting ArcMap and the machine, I only used the non-savable location... I'll accept the answer once I'm allowed to tomorrow. –  Flo Harrison Sep 11 '12 at 13:15
add comment

I just had the same propblem, minus the permission issues. I had a feature selected within the feature class that I was trying to export and that was the reason for my error. Once I cleared my selection, the export to shapefile worked.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.