I have multiple geodatabases with the same format in features and attribute tables, their difference is thier location, how I can combine them in one file in Access format which has one attribute table for each feature in Access file? I want to create one geodatabase from many mdb files which have same format, for example in all of them have same features with same attribute table , how can I create one Access file with them?

closed as unclear what you're asking by PolyGeo Dec 28 '17 at 18:29

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 3
    Please Edit the question to specify which GIS software you intend to use to merge these Access databases. – Vince Dec 28 '17 at 12:55

I see a few options for this:

  1. If you have ArcGIS Desktop you may create a new mdb in Catalog and then use the Merge tool to merge each like name fc from the two mdb and create the new layers in the new mdb (more of a manual process).

  2. If you have FME you could setup a simple reader and writer object that merges like name mdb fc and creates them in a new mdb

  3. If you have QGIS or gdal ogr2ogr you may use OSGeo4W command terminal to merge both mdb fc together to a new mdb (this will automatically merge like name fc)

  • I have hundreds geodatabase with same format, Merge order is cmplicated way through ArcGIS – Adel yavari Dec 28 '17 at 19:22
  • I would recommend option 2 or 3 then so you can do it in batch. – artwork21 Dec 28 '17 at 21:17

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