Executing R script from Access

[MilaK]

Hello,

I would like to send a query to R and execute R script from a command button in Access. Has anyone done this before and can suggest how to implement this?

Thanks,

Mila

 

[Uncle Gizmo]

All I could find is:-

A million ways to connect R and Excel

 

[sneuberg]

Maybe this Web page will help.

If there's no API for R in Access maybe you do this the other way around and use the Shell function to execute the R program.