ms access --> mysql --> R in Linux
mdbtools claims to have an ODBC driver, so no conversion should be necessary, just use RODBC. Both last time I tried and just now I could not get it to compile. The problems were in its Gtk front end, but that appears not to be optional.
On Mon, 1 Nov 2004, Anne York wrote:
I am trying to use some ms access databases in R (version 1.9.1 or 2.0 on a Debian system). In searching the net for promising software to do this, I found mdbtools. Mdbtools claims the ability to convert schemas and tables in MS Access to MySQL and other databases. http://mdbtools.sourceforge.net/ I'm wondering if anyone in the R community has tried using this software to use MS-Access databases in R with a Linux system. If so, Were you successful? What kind of problems did you encounter?
Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595