Re: [R] RODBC : using and passing queries that use in some arguments

Dear R users, I am trying to connect R to data that is in a Access Database but I have problem with the construction of queries using special characters. I am using RODBC package. The following is working : MyQuery-paste(SELECT first( (DateHeure) ) , avg(NNO3_AT322_OUT_moy) AS Cond FROM

Re: [R] RODBC : using and passing queries that use in some arguments

Start by using single quotes in your paste() command. dumb example: sql - paste(' select x = 3 ') (the query is nonsense, I just wrote it to show how to get double quotes into the query) -Don At 6:45 PM +0200 9/21/09, BOISSON, Pascal wrote: Dear R users, I am trying to connect R to data