Re: [R] MS-Access and R

From: Andreas Hary <u08adh_at_hotmail.com>
Date: Mon 12 Jun 2006 - 00:26:42 EST

Have a look at odbcConnectAccess in the RODBC package. Cheers,

Andreas

> 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@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
>



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 Received on Mon Jun 12 01:48:06 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 Mon 12 Jun 2006 - 02:12:41 EST.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.