[R] Loading mdb

[ROLL Josh F]

I am trying the RODBC package and the odbcConnectAccess function but am getting an error:

Error in odbcConnectAccess("T:/Models/LandUse/GenericLandSupplyModel/Projects/2008BaseYear/EugeneUGB/
Reporting/Summary.mdb") : 
  odbcConnectAccess is only usable with 32-bit Windows

I am on a 64 bit machine. I cant seem to locate a 64 bit counterpart.  
 

-----Original Message-----
From: Phil Spector [mailto:spector at stat.berkeley.edu] 
Sent: Tuesday, March 22, 2011 1:01 PM
To: ROLL Josh F
Cc: r-help at r-project.org
Subject: Re: [R] Loading mdb

I believe that you are misinterpreting the error message.
The mdb-get function relies on external programs named "mdb-tables" and "mdb-schema" to do its work.  Those programs must be installed on your computer (and in directories in your search path), for the function to work.
I don't know what operating system you are using, but the mdb tools are designed for non-Windows systems.

 					- Phil Spector
 					 Statistical Computing Facility
 					 Department of Statistics
 					 UC Berkeley
 					 spector at stat.berkeley.edu




On Tue, 22 Mar 2011, LCOG1 wrote:

> Well im thoroughly frustrated after 25 minutes of checking and 
> rechecking my path.  What do i not know about loading a mdb that is 
> keeping me from loading my data.
>
> i have loaded the Hmisc library and pointed it too my data using 
> mdb.get and continue to get the following error.
>
> Error in system(paste("mdb-tables -1", file), intern = TRUE) :
>  'mdb-tables' not found
>
> Which i realize is saying that its not reading any tables within the 
> mdb or not able to find any mdb at all at that location.
>
> the command i use is simply:
>
> RawInv.data..<-mdb.get('T:/Models/LandUse/GenericLandSupplyModel/Proje
> cts/2008BaseYear/EugeneUGB/Reporting/Summary.mdb')
>
> There is definitely a mdb in that location and the path is definitely 
> correct.  Its an MS Access mdb with 4 tables.  When i open the said 
> mdb i have to hit enter at a password window but no password is 
> required.  Could this be hanging up R from reading it?  I have 
> typically used dbf and csv or txt for import formats and am not real 
> familiar with mdb but i realize how elementary this question is but i 
> have spent 25 minutes now.  What am i missing.
>
> Thanks
>
> JR
>
>
>
>
> --
> View this message in context: 
> http://r.789695.n4.nabble.com/Loading-mdb-tp3397075p3397075.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide 
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>