So I followed the instruction here: Can QGIS read an ODBC connection? for adding a .mdb into QGIS. There are great instructions about 1/3 of the way down. But I still can't get it to open. I on Windows 7 with QGIS 2.4 I restarted QGIS and my computer. I am still getting the error: "Invalid Data Source: ODBC:co2014ProdSumm (btw this is the .mdb) is not a valid or recognized data source. "
These are not vector layers nor is this a ESRI personal geodatabase. This is an Access database with 2 tables I need out of it.
I also found a few other postsHow to access a .mdb file (Microsoft Access) in Qgis (with windows 7)?How to import info from mdb file?
and this one might be the answer but I don't know what it's talking about:Microsoft Access mdb "is not a valid or recognized data source" in QGIS
Is there any way to add a .mdb into QGIS? Also I do not have Access on my computer.
Edit 1:I hope this clarifies my issue. Each time I get Invalid Data Source: C:...Co 2014 Annual Production Summary-xp.mdb is not a valid or recognized data source.Here is where I added the access connection
Trying to add as a vector file
Trying to add a database, I also tried local:host 3000 The error in the pic is the same no matter the source, name etc... I've tried changing all fields around.
أكثر...
These are not vector layers nor is this a ESRI personal geodatabase. This is an Access database with 2 tables I need out of it.
I also found a few other postsHow to access a .mdb file (Microsoft Access) in Qgis (with windows 7)?How to import info from mdb file?
and this one might be the answer but I don't know what it's talking about:Microsoft Access mdb "is not a valid or recognized data source" in QGIS
Is there any way to add a .mdb into QGIS? Also I do not have Access on my computer.
Edit 1:I hope this clarifies my issue. Each time I get Invalid Data Source: C:...Co 2014 Annual Production Summary-xp.mdb is not a valid or recognized data source.Here is where I added the access connection
Trying to add as a vector file
Trying to add a database, I also tried local:host 3000 The error in the pic is the same no matter the source, name etc... I've tried changing all fields around.
أكثر...