Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 2 down vote favorite

How do I merge 2 tables (they both have the same field names and columns) in ArcGIS 9.3.1 ?

Thanks,

share|improve this question
please clarify. If you have key values you can do a join or relate. this only temporarily "merges the tables. any like column names will be treated (temp) as mytable1.myfield and mytable2.myfield. you can create a permanent version. If that is what you are looking for. – Brad Nesom Aug 15 '11 at 19:33
1  
Going off @Brad Nesom, if you export the file with the joins, it creates a new shapefile including the joined data but without the disadvantages of a join. – Emily Aug 16 '11 at 19:53

2 Answers

up vote 2 down vote accepted

The Merge tool

Data Managment Tools > General > Merge

share|improve this answer
This one is good to do the merge easily. – PROBERT Aug 15 '11 at 19:58
up vote 2 down vote

Or get the python window open and:

gp.merge_management(fc1, fc2)

or 

gp.Append_management(fc1, fc2,"NO_TEST")

Where fc1 can be a list of featureclasses merged into fc2. There are many ways to do this, but this for me would be the easiest as all you have to do is typre the first part, then drag in the names from the fc's from the TOC. Very easy.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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