Re: [R] creating MS Access query objects using RODBC

2009-08-06 Thread Dieter Menne
Tim Calkins-2 wrote: > > I'm trying to use R to create an MS Access query object. In particular, I > would like to pass a given sql statement to a variety of Access files and > have that sql statement saved as an Access Query in each db. Is this > possible using R? > > I'm aware that I could u

[R] creating MS Access query objects using RODBC

2009-08-05 Thread Tim Calkins
Hi - I'm trying to use R to create an MS Access query object. In particular, I would like to pass a given sql statement to a variety of Access files and have that sql statement saved as an Access Query in each db. Is this possible using R? I'm aware that I could use RODBC sqlQuery and write sql to