I'm new to Programing in R & RStudio.
I want to connect to an ACCESS DB but I'm encountering the following issue:
conn <- dbConnect(odbc::odbc(),
-
Driver = "Microsoft Access Driver (*.mdb, *.accdb)",
-
DBQ = "C:/Users/ADMIN/Documents/PUBLIC_DATA/Data.accdb")
Error in dbConnect()
:
! ODBC failed with error IM002 from [Microsoft][ODBC Driver Manager].
Data source name not found and no default driver specified
From nanodbc/nanodbc.cpp:1150.
Is this a 32-bit v 54-bit issue? Am I missing a call to the ODBC drivers? Any help greatly appreciated.
Thx,
Frank