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. <sixpackadelic@yahoo.com> 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]]
>
> ______________________________________________
> R-help@stat.math.ethz.ch 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]]

