Read data from MS Access into R on Mac OS 10.5
To read tables that are within a Microsoft Access Database, R needs the mdb-tools executables mdb-tables, mdb-schema, and mdb-export to be installed and in the system path. Since compiling those is not trivial, I have provided the binaries here, which I compiled from mdb-tools version 0.6pre1. Support is for Access 97 (Jet 3) and Access 2000/2002 (JET4) formats.
USE AT YOUR OWN RISK. You need to know what you are doing.
- Download the necessary mdb-tools binaries and untar in /usr/local/bin.
- Download the mdb libraries and untar in /usr/local/lib.
- If you don’t have those, download glibs and intllibs and untar in /usr/local/lib.
For testing, you can download a sample MS Access Database from anywhere, for example here.
In R you need to load library (Hmisc) and use mdb.get.
No TweetBacks yet. (Be the first to Tweet this post)
This worked for me, thanks! Tried compiling from source and never could get it to work, so I’m glad this option is here.