Steven - I use RODBC. Thx,

- Alex


________________________________
From: Steven Kennedy <stevenkennedy2263@gmail.com>
To: Alex Zhang <alex.zhang@ymail.com>
Cc: "r-help@R-project.org" <r-help@r-project.org>
Sent: Wednesday, July 6, 2011 7:18 PM
Subject: Re: [R] How to Execute A Query Stored In Access 2007

What package are you using to connect to the Access database?


On Thu, Jul 7, 2011 at 7:02 AM, Alex Zhang <alex.zhang@ymail.com> wrote:
> Hey guys,
>
> Could you please teach me how to run or execute a query stored in an Access 2007 database?
>
> I can connect and run queries from my Access database without any problem. But I have an append query stored there. Say called "Append2Tbl". How do I execute it without copying and pasting the query into my R code? Thanks a lot!
>
> - Alex
>        [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help@r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>
	[[alternative HTML version deleted]]

