Reading MS Access Database Files?
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 _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._