Hello Jake, Sorry this is from a few weeks ago- I just ran across a helpful document that gives a step by step for Access to QGIS:
http://elogeo.nottingham.ac.uk/xmlui/handle/url/48 The whole site seems to be worthy of a look through, seems there's a lot of helpful stuff. I am still using Access, but have also started to play around with Spatialite (which can be read in Access also via odbc). Check out Geokettle: http://www.spatialytics.org/projects/geokettle/ It is useful for moving around data, importing to other databases/formats, it can be a good when you are using/experimenting with different programs. Have a great day! Koos On 2/28/12, Jake Maier <[email protected]> wrote: > Thanks Koos > OK I copied it to the OSGeo4W folder. But what next. > Please remember that I am new to qgis. > How do I now get the shape file linked? > Thanks > Jake > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Koos Hagg > Sent: Sunday, February 26, 2012 10:23 PM > To: [email protected] > Subject: [Qgis-user] RE: joining ms access to shapefile > > Hi Jake, > > I forgot to mention that the ODBC drivers for Access .mdb are 32 bit, not > 64, so if you just go through your regular control panel it doesn't work. > > the 32 bit ODBC driver utility is still on your computer, in > C:\Windows\System32, a .exe called "odbcad32.exe" > I usually copy this program to somewhere in my OSGeo4W folder so I don;t > have to go hunting for it every time. > > Hope this helps, > Koos > > > ------------ > > Date: Sun, 26 Feb 2012 06:49:28 -0500 > From: "Jake Maier" <[email protected]> > Subject: RE: [Qgis-user] RE: joining ms access to shapefile > > 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 > _______________________________________________ > 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
