I am attempting to export selected features from a streets.sdc layer using ArcMap 10.1. After using the 'select by attribute' tool to select the features I want, I then right-click the data layer, choose Data --> Export data, and export the selected features as a new shapefile.
After successfully exporting these features I find that the new attribute table has been altered. For example, many values in the speed limit attribute column have reverted to zero. In addition, other values have been shifted around into different, incorrect attribute columns. For example, the name of a highway may be cut in half, with half of the name remaining in the 'Highway name' attribute column, and the other half migrating to the next attribute column to the right.
How do I prevent the attribute table from being corrupted when I create a new shapefile using selected features?