Have a look at odbcConnectAccess in the RODBC package.
Cheers,
Andreas
----- 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
>