[R] creating MS Access query objects using RODBC

[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 use RODBC sqlQuery and write sql to make a table or
> that I could run the sql, extract it to R, and then use sqlSave to save
> the
> dataframe as a table in the db.
> 
> 

To my knowledge, this is not possible using RODBC, because ODBC is the least
common denominator for many databases, and adding a query (~"view") to
Access is not within that standard.

It should be possible with COM, but I believe it will only work if you have
Access installed, not with mdb files alone.

Dieter




-- 
View this message in context: http://www.nabble.com/creating-MS-Access-query-objects-using-RODBC-tp24838858p24840834.html
Sent from the R help mailing list archive at Nabble.com.