R help - Aug 2009 - creating MS Access query objects using RODBC

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

thanks in advance,

-- 
Tim Calkins
0406 753 997

	[[alternative HTML version deleted]]

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.