Importing Microsoft Access file giving error

General
1

Hi,

I'm trying to import a Microsoft Access file into R. I used the code below:

install.packages("RODBC")
library(RODBC)

# Connect to the Access database
conn <- odbcConnect("C:/Users/Documents/MSI/MSI Data/MSI_Import/LAB.accdbc")

I keep getting this error:

Warning messages:
1: In RODBC::odbcDriverConnect("DSN=C:/Users/Documents/MSI/MSI Data/MSI_Import/LAB.accdbc") :
[RODBC] ERROR: state IM010, code 0, message [Microsoft][ODBC Driver Manager] Data source name too long
2: In RODBC::odbcDriverConnect("DSN=C:/Users/Documents/MSI/MSI Data/MSI_Import/LAB.accdbc") :
ODBC connection failed

Any help is really appreciated.

Thank you

2

This topic was automatically closed 42 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.