Qgis打开arcgis的MDB文件

时间:2024-04-04 07:18:36

QGIS: Accessing a Personal Geodatabase

http://www.northrivergeographic.com/qgis-accessing-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).Qgis打开arcgis的MDB文件

3. Open the ODBC Tools Menu.

Qgis打开arcgis的MDB文件

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.

Qgis打开arcgis的MDB文件6. Open QGIS.

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

Qgis打开arcgis的MDB文件

 

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.

Qgis打开arcgis的MDB文件

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.

Qgis打开arcgis的MDB文件