gistfile1.txt

# How to open MS Access databases on R

# 1. Download UCanAccess https://sourceforge.net/projects/ucanaccess/
# 2. Install RJDBC package in R

# Example:

library(RJDBC)

options(java.parameters = "-Xmx4g")

conn <- dbConnect(JDBC("net.ucanaccess.jdbc.UcanloadDriver",
                       "/Downloads/UCanAccess-4.0.4-bin/loader/ucanload.jar"), "jdbc:ucanaccess:///Downloads/base_datos_eodStgo_2012.accdb")

dbListTables(conn)
dbFetch(dbSendQuery(conn, "SELECT * FROM `Comuna Origen`"))

t <- dbSendQuery(conn, "SELECT * FROM Viaje WHERE ComunaOrigen = 71 AND ComunaDestino = 71 LIMIT 10")
dbFetch(t)