Thanks Koos, I seem to have a problem with the drivers. Looking at the ODBC Data Source Administrator I see the dBase Files, the Excel Files and the MS Access Database listed under User DSN, but when I try to configure them I get 2 messages. First "the setup routines for the Microsoft Access Driver could not be found. Please reinstall the driver" and the second "the specified DSN contains an architecture mismatch between the Driver and Application". I seem not to be able to set up a driver, but get stuck with empty choices in subsequent drop down lists Do you (or anyone else) please point me in the right direction to reinstall the drivers. The error messages show up for all three drivers installed. Thanks for any help in advance Jake
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Koos Hagg Sent: Saturday, February 25, 2012 8:26 PM To: [email protected] Subject: [Qgis-user] RE: joining ms access to shapefile Hi Jake, I have worked a bit with Access and QGIS together...from my experience it works best when your database is saved in an older format (.mbd). You can add the .mdb as an ODBC connection or (if I remember correctly) the better way is to add it simply as a vector layer. The only thing I don't like about it is that it is a static connection (read only), but it works... Koos >Date: Sat, 25 Feb 2012 14:00:11 -0500 >From: "Jake Maier" <[email protected]> >Subject: [Qgis-user] joining ms access to >shapefile >To: <[email protected]> >Hi I'm new to qgis (I have some ArcMap >experience) and I'm having >problems joining a ms access database to a shapefile. I'm >using >windows 7 and ms office 2007. I tried to google the information >about >a join of access to shapefile but got more confused in the process >instead. >Can anyone please help and give me some pointers. >Thank you very much >Jake _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
