[R] Loading mdb

[Phil Spector]

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/Projects/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.
>