I need to import info on a QGIS project.

The info are in a MDB file (population, mean age, number of cars and so on: one record per region) that is written to be connected with a region shape from an unique ID (the ID is the same in the MDB and in the QGIS shapefile).

  • 1
    load as esri personal geodatabase? [.mdb] match by id - or save the mdb as .dbf or csv and load in..
    – Mapperz
    Jun 25, 2012 at 17:19
  • the info are coming from a database not connected with GIS. I am not able to load my file info.dbf (exported from info.mdb)
    – Ale
    Jun 26, 2012 at 8:12
  • See also: Can QGIS read an ODBC connection? Oct 22, 2013 at 20:02

3 Answers 3


Keep in mind that QGIS 1.8 on Windows supports .mdb under Layer->Add Vector Layer...->Browse->and change the file type in the drop-down to the right of the "File name"" form field.

But.... QGIS 1.8 on OSX does not support opening of .mdb's (afaict)


WARN: it seems the 'Join Attributes' function ha been removed from fTools 0.6.2, solution for me was to downgrade to 0.6.1.

You can use QGIS to perform the operation you want, please proceed as follows:

  1. if not installed already, install Quantum GIS (an Open Source desktop GIS) and then install fTools as described here
  2. export the mdb table or query into dbf format (from Access, select the object, right click, export)
  3. open the region shapefile in qgis
  4. click on the Vector menu, Data management, Join attributes (I am translating roughly from my localized version)
  5. fill out the dialog and then click ok
  6. you should now have another layer with data from btoh the region shapefile and the dbf file

See the image below for an example:

Usage example

  • 1. done (QGIS v1.7.4) 2. done 3. done (the existing shape eg. "Town.shp", without my info) 4. done 5. is asks: "vector output" and "join vector" but I cannot find my file "info.dbf". I think "output shapefile" is the name of my new shape
    – Ale
    Jun 26, 2012 at 8:10
  • I have updated my answer
    – unicoletti
    Jun 26, 2012 at 10:05
  • my Vector menu/Data Managment is a bit different (Qgis 1.7.4) and I am not able to find the new layer coming from info.dbf
    – Ale
    Jun 26, 2012 at 13:04

This solutions works:

  1. / 2. / 3. done (thanks to @Unicoletti reply)
  2. add vector and choose your exported file ("info.dbf" in this case)
  3. you can see the new layer in the left bar
  4. double-click on the original layer ("town") and go in the menu join
  5. add a new join choosing the layer "info"
  6. choose the colum to match in each file
  7. you should have in the original layer the data coming from your DB

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.