View Table in Access Through R

Question

My machine is 64 bit, I would like to know how to connect R to a table in Access (2016). As an example to facilitate, suppose the table in Access is called MAT and the Access file is in a folder in C:. Grateful.

Answer 1

I’ve had a problem like this and solved it by following the following procedure: Getting Access data into R

Basically, you will need the package RODBC, which will allow you to access a variety of databases via ad connection ODBC.

I did not write code in the answer because I found it unnecessary, since the tutorial I suggested is super complete and covers, inclusive, how to make the connection configuration ODBC.

I used it a while ago, so it might be outdated. Take a look at the package documentation as well: RODBC Documentation.

I hope I’ve helped!