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:spec...@stat.berkeley.edu]
Sent: Tuesday, March 22, 2011 1:01 PM
To: ROLL Josh F
Cc: r-help@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
spec...@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@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.
>
______________________________________________
R-help@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.
