topic Create a shapefile from database table in Data Management Questions https://community.esri.com/t5/data-management-questions/create-a-shapefile-from-database-table/m-p/93582#M5511 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>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 &gt; display xy data, and then data&gt;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? </SPAN><BR /><BR /><SPAN>Grateful for answers!</SPAN></BODY></HTML> Tue, 24 Apr 2012 12:11:35 GMT AnnaHenriksson 2012-04-24T12:11:35Z Create a shapefile from database table https://community.esri.com/t5/data-management-questions/create-a-shapefile-from-database-table/m-p/93582#M5511 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>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 &gt; display xy data, and then data&gt;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? </SPAN><BR /><BR /><SPAN>Grateful for answers!</SPAN></BODY></HTML> Tue, 24 Apr 2012 12:11:35 GMT https://community.esri.com/t5/data-management-questions/create-a-shapefile-from-database-table/m-p/93582#M5511 AnnaHenriksson 2012-04-24T12:11:35Z Re: Create a shapefile from database table https://community.esri.com/t5/data-management-questions/create-a-shapefile-from-database-table/m-p/93583#M5512 <HTML><HEAD></HEAD><BODY><SPAN>It probably has something to do with your table fields having invalid characters.&nbsp; Here is a KB Articles on </SPAN><A href="http://support.esri.com/en/knowledgebase/techarticles/detail/30888">How To: Format a table in Microsoft Access for use in ArcMap</A><SPAN>&nbsp; </SPAN><BR /><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Formatting_a_table_in_Microsoft_Access_for_use_in_ArcGIS/005s00000022000000/">Formatting a table in Microsoft Access for use in ArcGIS</A></BODY></HTML> Tue, 24 Apr 2012 14:45:54 GMT https://community.esri.com/t5/data-management-questions/create-a-shapefile-from-database-table/m-p/93583#M5512 TimothyHales 2012-04-24T14:45:54Z