Create a shapefile from database table

[AnnaHenriksson]

Hi,

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!

[TimothyHales]

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