[R] How to Execute A Query Stored In Access 2007

[Steven Kennedy]

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.zhang at ymail.com> wrote:
> Steven - I use RODBC. Thx,
> - Alex
> ________________________________
> From: Steven Kennedy <stevenkennedy2263 at gmail.com>
> To: Alex Zhang <alex.zhang at ymail.com>
> Cc: "r-help at R-project.org" <r-help at 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 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.
>>
>
>
>