[Qgis-user] Re: joining ms access to shapefile

[Koos Hagg]

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 <j.m at jmforestry.com> 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: qgis-user-bounces at lists.osgeo.org
> [mailto:qgis-user-bounces at lists.osgeo.org] On Behalf Of Koos Hagg
> Sent: Sunday, February 26, 2012 10:23 PM
> To: qgis-user at lists.osgeo.org
> 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" <j.m at jmforestry.com>
> 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
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>