• Skip to primary navigation
  • Skip to main content

North River Geographic Systems Inc

Spatial Problem Solving

  • Home
  • About NRGS
  • Blog
  • Resources
    • Guides for using TN Data with QGIS
    • QGIS Resources
    • Tutorials
  • Services
    • Support Services
    • Tennessee NG911 Address Server
    • Training
    • Forestry Database Services
    • Conservation GIS
    • Data Analysis
  • Portfolio
  • Show Search
Hide Search
You are here: Home / QGIS: Accessing a Personal Geodatabase

QGIS: Accessing a Personal Geodatabase

  • Software: QGIS 2.4-2.8
  • Operating System: Windows 7

So ArcGIS for a while was promoting the Personal Geodatabase. The ESRI Personal Geodatabase was based on Microsoft Access. It’s a format that is probably going to be phased out by ESRI at some point in the future. In case you run into it while using QGIS (on Windows Currently) – here is what you do.

1. Download and install the Microsoft Access Database Engine from http://www.microsoft.com/en-us/download/details.aspx?id=13255

2. In Windows 7 go to Administrative tools under control panel and open Data Sources (ODBC). odbctools

3. Open the ODBC Tools Menu.

odbcmenu

4. Add a connection. Select the Microsft Access Driver (*.mdb) and Click Finish.

5. Give the Connection a name and select the Personal Geodatabase.  In this case my Personal Geodatabase was called Flatrock. Click OK.

personalMDB6. Open QGIS.

7. Add Vector Layer. Select The database Radio Button.

vector

 

8. Select ESRi Personal GeoDatabase as the Type. Click New. Fill out the Information for the connection. Note the name of the Dsatabase will be the name of your ODBC Connection.

QGISConnect

9. Click OK. Click Open. If prompted for a password just hit your spacebar once and click OK. Enjoy getting your data out of a Personal Geodatabase.

addlayers

 

 

 

Contact

  • (423) 653-3611
  • info@northrivergeographic.com

Copyright © 2021 · Monochrome Pro on Genesis Framework · WordPress · Log in

  • Home
  • About NRGS
  • Blog
  • Resources
  • Services
  • Portfolio