Re: [R] MS-Access and R

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

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


> 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]]
> ______________________________________________
> mailing list
> PLEASE do read the posting guide!
> mailing list PLEASE do read the posting guide! 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 Please read the posting guide before posting to the list.