R help - Jul 2011 - How to Execute A Query Stored In Access 2007

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

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


On Thu, Jul 7, 2011 at 7:02 AM, Alex Zhang <alex.zhang at 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 at 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.
>