Re: [R-SIG-Mac] 'Default' macos (x86) download URL now gone?
Simon, On 24 April 2023 at 18:28, Simon Urbanek wrote: | thanks - the problem is that there is not a single installer package (for several years now), so that URL is ambiguous. Whether the missing link is a good or bad depends on how it is used. I would argue that any link to that URL is inherently bad, because there is no way of knowing that the link works for a particular system - that's why I have originally removed it with the R 4.3.0 release. I have restored it now, making it point to the R 4.3.0 arm64 release since that is arguably the closest to a single "latest R". R releases have not been stored in /bin/macosx since 2015, so anyone using a link there is asking for trouble. Restoring it _but switching the architecture under it_ is another subtle way to still break things where the expectation based on a decade+ of prior practice was that this works: installer: Error - R 4.3.0 for macOS (ARM64) can’t be installed on this computer. Error: Process completed with exit code 1. I long have repaired my (main) script in r-ci but this will likely surprise others. | For any CI I would strongly recommend using the "last-success" links: https://mac.r-project.org/big-sur/last-success/ in particular the .xz versions are they are specifically designed to be used by CI (small download, fast and localized install). That is a fine idea but no replacement as it leads to a need for a different deployment and how / where to untar etc. Maybe you are someone wants to wrap that into a suitable script or 'action snippet' and document that? I can't, I don't even have a mac. Dirk -- dirk.eddelbuettel.com | @eddelbuettel | e...@debian.org ___ R-SIG-Mac mailing list R-SIG-Mac@r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-mac
Re: [R-SIG-Mac] Using Microsoft Access from a Macintosh using R
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
[R-SIG-Mac] Using Microsoft Access from a Macintosh using R
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
