Connecting to an MS Access database with R (x64)

Question

I am trying to access an Access database using R. I tried the following options, but I cannot connect to the database. I use 64-bit R and 64-bit access. I also use windows 7 .. :(

library(RODBC) db <- "E:/testdb.accdb" myconn <-odbcDriverConnect("Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=E:/test.accdb") con2 <- odbcConnect(db) channel <- odbcConnectAccess("E:/testdb") 

I always get an error. Please help me.

 1: In odbcDriverConnect("DSN=E:/testdb.accdb") : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 2: In odbcDriverConnect("DSN=E:/testdb.accdb") : ODBC connection failed 

Answer 1

I think the problem is with the error message: you do not have the Microsoft Access driver x64 installed. Check it on the control panel - ODBC Data Sources (x64) on the Drivers tab. If this does not happen, try installing the Redistributable Microsoft Access Database Engine 2010 .