ImportExport: odbcConnectAccess is only usable with 32-bit Windows

General
1

Hi

Is there a workaround for below "please:

require(ImportExport)
access_export("Database1",z,z)
Error in RODBC::odbcConnectAccess(file, uid = uid, pwd = pwd, ...) :
odbcConnectAccess is only usable with 32-bit Windows

2

Folks to be having success with the following

3

I use a connection string like this

library(odbc)
conexion <- dbConnect(odbc::odbc(),
                      .connection_string = "Driver={Microsoft Access Driver (*.mdb, *.accdb)};
                      Dbq=C:/path/to/your/access_file.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)

4

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.