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.

I need to import info on a QGIS project.

The info are in a MDB file (population, mean age, number cars and so on per Town) that is possible to connect with a region shape from an ID (the ID is the same in the MDB and in the shape file).

share|improve this question
1  
load as esri personal geodatabase? [.mdb] match by id - or save the mdb as .dbf or csv and load in.. –  Mapperz Jun 25 '12 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 '12 at 8:12
    
See also: Can QGIS read an ODBC connection? –  RyanDalton Oct 22 '13 at 20:02
add comment

3 Answers

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)

share|improve this answer
    
This is now again possible for Mac with the GDAL MDB Java-based driver. See this homebrew project pull request, which also has a patch file for GDAL 1.10.1 configure script. –  dakcarto Oct 22 '13 at 19:16
add comment

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

share|improve this answer
    
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 '12 at 8:10
    
I have updated my answer –  unicoletti Jun 26 '12 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 '12 at 13:04
add comment
up vote 2 down vote accepted

Solved!

  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
share|improve this answer
add comment

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.