ImportExport: odbcConnectAccess is only usable with 32-bit Windows


Is there a workaround for below "please:

Error in RODBC::odbcConnectAccess(file, uid = uid, pwd = pwd, ...) :
odbcConnectAccess is only usable with 32-bit Windows

Folks to be having success with the following

I use a connection string like this

conexion <- dbConnect(odbc::odbc(),
                      .connection_string = "Driver={Microsoft Access Driver (*.mdb, *.accdb)};
                      encoding = "latin1") # This is only for data with non ASCII characters

Have in mind that the "Driver" parameter could be different depending on your Microsoft Access version (older versions use a different database engine)

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