Displaying 1 result from an estimated 1 matches for "v1011".
Did you mean:
1011
2012 Mar 28
1
Is it possible to de-select with sqlQuery from the RODBC library?
...se with the sqlQuery function from the RODBC library. As I cannot make a working example with a database here is an illustrative example,
library(RODBC)
mdbConnect<-odbcConnectAccess("S:/data/ ... /databse.mdb")
data <- sqlQuery(mdbConnect, "select id, DOB, V1, V2, ..., V1009, V1011, V1013 from someTable")
I want everything in the table (someTable), except 'V1010' and 'V1012,' but I can't figure out how to make a negative or reverse SQL select statement. I have a lot of someTables and I have two or three variables in each table that I do not want R to...