Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Can ogr2ogr be used to append multiple DBF files? It works with SHP files, but I can't see how to do it with DBF files on their own. It ought to be possible, considering DBF is a subset of SHP.

share|improve this question
up vote 7 down vote accepted

Say you have three DBF files with the same field structure (schema), and you want to combine them into one all.dbf. From a system shell, use ogr2ogr with the -append flag:

$ ogr2ogr -append all.dbf a.dbf
$ ogr2ogr -append all.dbf b.dbf
$ ogr2ogr -append all.dbf c.dbf

These files can be either shapefiles or sole DBF files. It will work either way.

share|improve this answer
Alternatively, if you have dozens of files and all your shapefiles are in a single folder you can use the Vector->Data management Tools->Merge shapefiles to one tool in QGIS. Either, that or write a simple Python script to iterate Mike's solution above over the contents of a folder. – MappaGnosis Jan 4 '13 at 10:39

Your Answer


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.