Create a shapefile from database table

Discussion created by mael84 on Apr 24, 2012
Latest reply on Apr 24, 2012 by timothy_hales-esristaff

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!