[R-sig-Debian] How to open an access mdb using the rodbc package under Ubuntu 22.04

[Ivan Krylov]

On Fri, 17 Jun 2022 08:18:10 +0000 (UTC)
Chris Evans <chrishold using psyctc.org> wrote:

> I want to open a moderately large (830Mb) and moderately complex
> Access mdb database into R (4.2.0 (2022-04-22)) I'm running it under
> Ubuntu 22.04 and have pulled in and compiled unixODBC

ODBC needs an Access driver in order to work with Access databases. A
cursory web search gave me this commercial product:
https://www.easysoft.com/products/data_access/odbc-access-driver/index.html

There's also mdbtools <https://github.com/mdbtools/mdbtools>, which
also seems to offer an ODBC driver. It might also be able to let you
convert the Access database for a different SQL engine.

-- 
Best regards,
Ivan