rodbc - Reading a access database (mdb) in 64 bit in R -

I have a database and I have to read that I found some packages in R such as Hmisc And RODBC which are functions to do this I am using windows and were not able to use HMIC because you need the mdb-tools package And I did not find any way to install mdb-tools on any tutorials or windows.

Now, I was trying to start with RODBC I got this question "" which shows how Windows has a connection I accepted the answer to that question Tried to use the same command as

  odbcDriverConnect ("driver = {Microsoft Access driver (* .mdb, * .accdb)}; dbQ = e: / projects \ newdata / 2013 Database / Data / PGDABBCW.MDB ")  

This returns the following error: < / P>

  1: in odbcDriverConnect ("driver = {Microsoft Access driver (* .mdb, * .accdb)}, DBQ = E: / Projects \ NewData / 2013 Database / Data / PGDABCISWMDB" ): [RODBC] Error: State 01S 00, Code 0, Message [Microsoft] [ODBC Driver Manager] Invalid Connection String Attribute 2: ODBC Driver Connect ("= {Microsoft Access Driver (* .mdb, * .accdb)}, DBQ = E: / Projects \ NewData / 2013 Database / Zeta / PGDBCISWMDB "): ODBC Connection Failure  

I'm not sure how it is being investigated here, to find out and start I went to administrative equipment and" data sources ODBC) "to check the options. I changed the target to sysWOW

< P> Then I created a new data source as follows:

< / P>

I'm not sure whether I need to select a database or not. I found the RODBC tutorial of Brian Ripley, but still I am not able to work on it.

This works fine for me & amp; You can also work for:

  Required (RODBC) conn & lt; - odbcConnectAccess2007 (path.expand ("~ / Database.accdb") subset (sqlTables (conn), TABLE_TYPE == "table") df & lt; - sqlfetch (conn, "Table1") Close (conn)  

My sessionInfo () :

  #R version 3.1 .1 (2014-07-10) # Platform: x86_64-w64-mingw32 / x64 (64-bit) # # Other enclosed package: # [1] A namespace (and attachments) loaded by RODBC_1.3-10 # # No): # [1] ToolsAudio.1.1.1