[R] MS-Access and R

Andreas Hary u08adh at hotmail.com
Sun Jun 11 16:26:42 CEST 2006

Have a look at odbcConnectAccess in the RODBC package.


----- Original Message ----- 
From: "Carsten Steinhoff" <carsten.steinhoff at gmx.de>
To: <r-help at stat.math.ethz.ch>
Sent: Sunday, June 11, 2006 11:24 AM
Subject: [R] MS-Access and R

> Hello,
> is there a possibility to connect MS-Access and R, maybe via VBA-Code?
> I have an Access database connected to R (via odbc). Some calculations are
> done and the results are transfered back to Access where the user will 
> work
> further.
> To make the whole thing more user-friendly I'd like to do everything in
> Access.
> I know that there is a module for EXCEL in R-DCOM but my experience in
> programming is not good enough to make it ready for Access.
> Is there any ACCESS - example available for such a task? Maybe somebody
> already has done something similar and could send it to me.
> Thanks a lot!
> Carsten
> [[alternative HTML version deleted]]
> ______________________________________________
> R-help at 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

More information about the R-help mailing list