Having issue connecting an Access DB in RStudio

General
1

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].
:heavy_multiplication_x: Data source name not found and no default driver specified
:information_source: 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

2

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.