Create a shapefile from database table

04-24-2012 05:11 AM
New Contributor

I have a table in Access and I want to use it as a shapefile in ArcGIS. I've tried just adding the table and then right click the layer > display xy data, and then data>export data for the xy-data file. But the output from that is missing almost all values, it is just the first 4 columns that gets values the rest are just 0. What am I doing wrong?

Grateful for answers!
Tags (2)
0 Kudos
1 Reply
Esri Notable Contributor
It probably has something to do with your table fields having invalid characters.  Here is a KB Articles on How To: Format a table in Microsoft Access for use in ArcMap 

Formatting a table in Microsoft Access for use in ArcGIS
0 Kudos