Steven - I use RODBC. Thx, - Alex
________________________________ From: Steven Kennedy <stevenkennedy2...@gmail.com> To: Alex Zhang <alex.zh...@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.zh...@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]]
______________________________________________ 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.