[R] ms access --> mysql --> R in Linux

[Prof Brian Ripley]

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