1

I have a load of old data on a Microsoft access (accdb) file. I can't open it on my mac, is there a way to open it directly in R? Is there a package that will let me do this? I don't need to open it on my laptop anyway, just get it straight into R.

Thanks so much!

  • Package odbc (or the older RODBC), and a Microsoft Access Driver for MacOS will probably do the job. MS Office is available for the Mac, so there should be a database driver. (I don't know MacOS that well so this is just a comment). – knb Oct 23 at 10:24
  • @knb thanks very much! Sadly even though mac has MS Office, it is missing the Access Driver! It has everything else... very frustrating – Gabriella Oct 23 at 12:22
  • 1
    Maybe there is a free download of the driver, somewhere on the Microsoft website. Often these are wrapped in larger packages called "SDKs" e.g. DotnetSDK, OfiiceSDK etc. MS changes this all the time. And the driver is also sometimes called "Jet driver" (Jet is the codename of the SQL "engine") – knb Oct 23 at 12:25
0

REbaseData offer an online facility to convert the data tables from accdb files to a zip of Excel spreadsheets which I am sure that you can open with R - the pricing looks reasonable and includes 1 small file conversion for free as a trial.

| improve this answer | |
0

I ended up manually saving tables as excel files and importing them one by one into R.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.