To read tables that are within a Microsoft Access Database, R needs the
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.