[prev in list] [next in list] [prev in thread] [next in thread] 

List:       r-sig-mac
Subject:    Re: [R-SIG-Mac] Using Microsoft Access from a Macintosh using R
From:       Marc Schwartz via R-SIG-Mac <r-sig-mac () r-project ! org>
Date:       2023-04-26 12:02:46
Message-ID: etPan.644912e6.50996ee.e85e () me ! com
[Download RAW message or body]

Hi,

You have identified the key components that you will need, which are the RODBC \
package:

    https://cran.r-project.org/web/packages/RODBC/index.html

and the Actual Technologies ODBC driver pack for MS Access:

    https://www.actualtech.com/product_access.php

The latter has some basic installation instructions for that product on the above \
page, and Actual offers a limited function evaluation option, if you want to try \
before you buy. Actual also has their own tech support available. The key is using \
their tools to set up the correct DSN specification for the database that you want to \
retrieve data from within R.

I used to use the Actual ODBC driver pack for Oracle on my Mac, and it worked quite \
well, albeit, it has now been a few years since I needed that functionality.

For the RODBC package, it can be installed from within an R session using:

   install.packages("RODBC")

Note that Prof. Ripley has spent a significant amount of time over the years creating \
a vignette for the RODBC package:

    https://cran.r-project.org/web/packages/RODBC/vignettes/RODBC.pdf

in addition to the package manual, and I would urge you to review the vignette for \
helpful information.

That should get you started.

Note also that there is a specific e-mail list for R and databases:

    https://stat.ethz.ch/mailman/listinfo/r-sig-db

however the traffic on that list has been essentially non-existent for some time, and \
since this is a Mac specific issue, feel free to continue this thread, or post \
subsequent questions, here.

Regards,

Marc Schwartz



On April 26, 2023 at 6:50:10 AM, list_email--- via R-SIG-Mac (r-sig-mac@r-project.org \
(mailto:r-sig-mac@r-project.org)) wrote:

> How can I make a Mac get data from a Microsoft Access database using R?
> 
> I'm sorry if this has been asked a million times before but the list archives don't \
> seem to be searchable and the Mac FAQ doesn't mention this. 
> Also, I'm asking for a colleague who doesn't like messing around with a lot of \
> technical computer stuff and I do not have R on my own system. So please be \
> patient. 
> It seems that there is a package called RODBC which needs to be installed. Is that \
> done using R's package manager? 
> And it seems that there is a driver from Actual Technologies with a Mac installer \
> package. 
> Assuming that these two steps are taken, is there anything else that needs to be \
> done? Can R then access the Access database directly or is there an intermediate \
> step such as an Excel file? Is there a very short MWE that demonstrates accessing a \
> public Microsoft Access database using this method? 
> My colleague is thinking of buying a Windows system just to solve this problem!
> 
> Many thanks,
> 
> Jerry
> 
> _______________________________________________
> R-SIG-Mac mailing list
> R-SIG-Mac@r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-mac

_______________________________________________
R-SIG-Mac mailing list
R-SIG-Mac@r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-mac


[prev in list] [next in list] [prev in thread] [next in thread]