You should just be able to use the sqlQuery function to execute the query something like this:
con<-odbcConnect(...) sqlQuery(con,"EXEC <your procedure name here>") On Thu, Jul 7, 2011 at 11:40 AM, Alex Zhang <alex.zh...@ymail.com> wrote: > 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. >> > > > ______________________________________________ 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.
