[Qgis-user] How to Join Attribute Data - .MDB + ODC

[Stewart Galloway]

 Thanks for helping. I'll try again tomorrow.
    On Wednesday, May 13, 2026 at 04:15:13 PM EDT, chris hermansen <clhermansen at gmail.com> wrote:   

 Three things:   
   - I am guessing that if it's greyed out you may need to install some type of ODBC driver - but I'm just guessing.
   - I don't know if you're aware of this but an MDB is a Microsoft Access database.  ESRI Personal GeoDatabases are built in those files.
   - If you think it's an ESRI personal geodatabase then it probably has spatial stuff in it; it would be weird if someone used an ESRI personal geodatabase just to store attributes.
Since I don't use Microsoft products, I can't do much more to help you with this.
Have you read the link I sent?  Have you read the link Kirk Schmidt sent?
If neither of those helped, you should reply to Kirk's message saying that you have tried to add the MDB as a layer and it is greyed out.  Maybe someone on the list who is familiar with using MDB files can help you further.
And by the way, this list is completely 100% volunteer and replies are sent to questions in the earnest hope that they help.
It's customary to make all replies back to the list, not to the individuals who respond.  It's also customary to respond to all replies received (to the list) and to indicate whether the suggestions helped or not.
On Wed, May 13, 2026 at 1:05 PM Stewart Galloway <galloway99 at verizon.net> wrote:

 The MDB file is greyed out.  That is ESRI's legacy file.
    On Tuesday, May 12, 2026 at 05:09:47 PM EDT, chris hermansen <clhermansen at gmail.com> wrote:   

 Try adding it as a layer. You should get a prompt to select the individual tables in the . mdb.
On Tue, May 12, 2026, 14:06 Stewart Galloway <galloway99 at verizon.net> wrote:

 the non-spatial table is the MDB file.  How do I add it to the project?

    On Tuesday, May 12, 2026 at 12:36:16 PM EDT, chris hermansen <clhermansen at gmail.com> wrote:   

 Stewart and list,

On Tue, May 12, 2026, 08:26 Stewart Galloway via QGIS-User <qgis-user at lists.osgeo.org> wrote:

I have files from a county real property tax agency but I need help to join the data to the polygons.  I'm familiar with GDBs (polygons) and MDBs (attributes) but not how to join one to the other.I'm running ver 3.2 (see below for details).The following is a list of files and extensions:Thank you.Stewart
.ODC
Malta.gdb (folder): parcel polygons

The line above suggests your .mdb has spatial data in a table within it. Maybe this is an ESRI personal geodatabase?
If so, you need to
1. Find that table 2. Determine which attribute of that table contains a key value that corresponds to other tables in the .mdb3. Add the spatial and non spatial tables as layers
Then you can join the layers.
This article may help
https://gis.stackexchange.com/questions/129514/opening-esri-personal-geodatabase-mdb-in-qgis

 4140_25-Jun-25.mdb

CreateGridForSheetIndex (folder)Default.atbxDefault.gdbscratch.gdbFMV_DataIndexscratch.gdb

| 
QGIS version
 | 
3.20.0-Odense
 | 
QGIS code revision
 | 
decaadbb31
 |
| 
Qt version
 | 
5.15.2
 |
| 
Python version
 | 
3.8.7
 |
| 
GDAL/OGR version
 | 
3.2.3
 |
| 
PROJ version
 | 
6.3.2
 |
| 
EPSG Registry database version
 | 
v9.8.6 (2020-01-22)
 |
| 
GEOS version
 | 
3.9.1-CAPI-1.14.2
 |
| 
SQLite version
 | 
3.31.1
 |
| 
PDAL version
 | 
2.2.0
 |
| 
PostgreSQL client version
 | 
12.3
 |
| 
SpatiaLite version
 | 
4.3.0a
 |
| 
QWT version
 | 
6.1.4
 |
| 
QScintilla2 version
 | 
2.11.4
 |
| 
OS version
 | 
macOS High Sierra (10.13)
 |
| 


 | 


 | 


 | 


 |
| 
Active Python plugins
 | 
localcoordinates
qgis2web
qad
parcel_plugin
qgis-maptiler-plugin
db_manager
MetaSearch
processing
 |


_______________________________________________
QGIS-User mailing list
QGIS-User at lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

  


Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.  


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20260513/c6bdbec5/attachment.htm>