I have an Access file (*.mdb), and I want to join between this attribute data with its spatial data ? But other than (join & relate way) .

And I need it to be permanent .


You can perform permanent joins using the Join Field tool which:

Joins the contents of a table to another table based on a common attribute field. The input table is updated to contain the fields from the join table.


You did not mention which part of ArcGIS you have your join. In ArcMap, tabular joins are temporary by nature, To make a tabular join permanent you just need to export it to a new feature class.

If you are using the geoprocessing tools in the Toolbox (for Map or Catalog) or through python, you can use one of two methods. The 'Join Field' tool (under Data Management Tools/Joins) will update the input table to include the joined data. This alters the schema of your original data (there is no undo option).

The other method is to use the 'Add Join' tool (again under Data Management Tools/Joins) to create the join in memory like ArcMap's normal interface does and then use the 'Feature Class to Feature Class' tool (under Conversion Tools/To Geodatabase) to export to a new shapefile or geodatabase layer.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.