Ray,
R can talk to Ms access very well through RODBC. Here is how:
mdbConnect<-odbcConnectAccess("C:\\temp\\demo.mdb");
sqlTables(mdbConnect);
demo<-sqlFetch(mdbConnect, "tblDemo");
odbcClose(mdbConnect);
rm(demo);
On 6/23/06, Ray D. <[EMAIL PROTECTED]> wrote:
>
> Hello, does anyone know how I would go about getting R to connect to
> OpenOffice's Base program (OOo's version of MS Access) such that I can
> retrieve data from the database and perform calculations and data
> analysis? I'm totally new to R and Base and I've looked at some
> documentation, but found only examples for R connecting to PostgreSQL and
> MySQL, but nothing for OOo's Base (there wasn't any examples for MS Access
> either even though it says that R can connect to MS Access). Is R even
> capable of this or am I just out of luck to use R and OOo's Base
> together? Thanks in advance.
>
> -ray
>
>
> ---------------------------------
>
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> [email protected] mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide!
> http://www.R-project.org/posting-guide.html
>
--
WenSui Liu
(http://spaces.msn.com/statcompute/blog)
Senior Decision Support Analyst
Health Policy and Clinical Effectiveness
Cincinnati Children Hospital Medical Center
[[alternative HTML version deleted]]
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
