Hi,
On 3/7/07, j.joshua thomas <[EMAIL PROTECTED]> wrote:
>
> I have used RODBC to get the database i can view the tables in RGUI-2.4.1
> how can i query the records in R>
> i tried with sqlQuery
>
> need some help
>
> A bit of code showing what you did would help others to track down what
may have gone wrong.
Nevertheless, this is code I used under R 2.3.1 on WinXP:
library(RODBC)
myaccessDB <- "c:/data/db1.mdb"
connectedMSAcc <- odbcConnectAccess(myaccessDB)
sqlTables(connectedMSAcc) # all the tables in the Access DB
onetable <- sqlFetch(connectedMSAcc, "lexp") # fetching one table called
'lexp'
myQuery <- "SELECT Country, y2001 FROM lexp WHERE y2001 > 82;"
myresults <- sqlQuery(connectedMSAcc, myQuery)
myresults
I hope this helps?
Best,
Roland
[[alternative HTML version deleted]]
______________________________________________
R-help@stat.math.ethz.ch 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.
