Displaying 1 result from an estimated 1 matches for "tbldatafieldrawsitevisit".
2012 Oct 26
1
Package RODBC sqlQueries
...ociated with the RODBC package, but I'm still having problems with
my SQL statements; I think my syntax, particularly with respect to my
WHERE statement, is off but I can't find any documentation as to why.
When I run a query from within the Access2007 database, it looks like this:
SELECT tblDataFieldRawSiteVisit.*
FROM tblDataFieldRawSiteVisit
WHERE (((tblDataFieldRawSiteVisit.dataForm)="Oyster Transition Plan
Site Mapping Detail"));
After inserting that (verbatim) into my R code like this:
testData = sqlQuery(db, SELECT tblDataFieldRawSiteVisit.*
FROM tblDataFieldRawSiteVisit
WHERE (((tblDataF...