Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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 2

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

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.