[R] Reading MS Access Database Files?

[Prof Brian D Ripley]

On 1 Mar 2001, A.J. Rossini wrote:

> >>>>> "PD" == Peter Dalgaard <BSA <p.dalgaard at pubhealth.ku.dk>> writes:
>
>
>     PD> "Richard A. Bilonick" <rab at nauticom.net> writes:
>     >> Does anyone know of a way to convert or read MS Access database
>     >> files under Linux so I can access them in R? I had contacted
>     >> Concdeptual Software about DBMS/Copy and they assured me that
>     >> the Linux version could handle Access files. Of course, when I
>     >> purchased it then they said that it couldn't read MS Access
>     >> files.
>     >>
>     >> Rick Bilonick
>
>     PD> I don't think I can come up with anything not involving a
>     PD> Windows OS.
>
>     PD> With something like Win4Lin and R for windows, I think you can
>     PD> set up an RODBC connection to the file.
>
> Why not the unixodbc drivers?   (someone who should remain nameless so
> he won't get pestered suggested that they might work).

I believe that using Access from Linux needs an ODBC-ODBC bridge on a
Windows server.  Put another way, unixODBC can't have drivers for a
database that does not run on Linux.

www.unixodbc.org says

Microsoft Access

You can use a Bridge to get to a ODBC data source on a Windows machine

See the ODBC-ODBC Bridge entry


B.

-- 
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 272860 (secr)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._