Re: [R] R connectivity to database

From: Wensui Liu <>
Date: Sat 24 Jun 2006 - 05:02:13 EST


R can talk to Ms access very well through RODBC. Here is how:



demo<-sqlFetch(mdbConnect, "tblDemo");



On 6/23/06, Ray D. <> 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]]
> ______________________________________________
> mailing list
> PLEASE do read the posting guide!

WenSui Liu
Senior Decision Support Analyst
Health Policy and Clinical Effectiveness
Cincinnati Children Hospital Medical Center

	[[alternative HTML version deleted]]

______________________________________________ mailing list
PLEASE do read the posting guide!
Received on Sat Jun 24 05:06:31 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Sat 24 Jun 2006 - 06:12:38 EST.

Mailing list information is available at Please read the posting guide before posting to the list.