Import info from mdb file into a project?

Question

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).

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 08:12

score 5 · Answer 1 · answered Nov 20 '12 at 06:08

5

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)

answered Nov 20 '12 at 06:08

jeffme

155
2
8

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

unicoletti · Answer 2 · 2012-06-26T10:05:43.523

3

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:

if not installed already, install Quantum GIS (an Open Source desktop GIS) and then install fTools as described here
export the mdb table or query into dbf format (from Access, select the object, right click, export)
open the region shapefile in qgis
click on the Vector menu, Data management, Join attributes (I am translating roughly from my localized version)
fill out the dialog and then click ok
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

edited Jun 26 '12 at 10:05

answered Jun 26 '12 at 06:42

unicoletti

7,339
22
33

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 08: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

Ale · Accepted Answer · 2014-10-05T08:25:27.293

2

This solutions works:

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

edited Oct 05 '14 at 08:25

answered Jun 26 '12 at 13:01

Ale

1,313
4
26
48

Import info from mdb file into a project?

3 Answers3

Linked