Stefano,
It did work - for some reason, the date components to be used in the sqlQuery
need to be placed in between hashes (i.e., #) for them to be interpreted
correctly.
Thank you so much.
Tudor
Quoting Guazzetti Stefano <[EMAIL PROTECTED]>:
> It seems that Access needs that you surround the
It seems that Access needs that you surround the dates with a # symbol.
You probably need something like.
res <- sqlQuery(channel, "select * from test_table where market = 'atl-bos'
and competitor = 'delta' and dd = #2007-11-20#")
Hope this helps,
Stefano
-Messaggio o
2 matches
Mail list logo
