Re: [R] R connectivity to database

2006-06-23 Thread Juan Antonio Breña Moral
You should download ODBC Driver and use RODBC Package; Best Regards. Juan Antonio Breña Moral. Advanced Marketing Ph.D. , URJC, Spain (Now) Industrial Organisation Engineering, ICAI, Spain. Technical Computer Programming Engineering, ICAI, Spain Web: http://www.juanantonio.info Mobile: +34 65597

Re: [R] R connectivity to database

2006-06-23 Thread Prof Brian Ripley
You have not told us your platform nor version of OO (nor what 'it' is which 'says that R can connect to MS Access'). R can certainly connect to MS Access on Windows via RODBC, which does come with Access examples. I think though that it is unrealistic to claim that Base is 'OOo's version of M

Re: [R] R connectivity to database

2006-06-23 Thread Wensui Liu
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 h

[R] R connectivity to database

2006-06-23 Thread Ray D.
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