library(RODBC)
channel<-odbcConnect("mike_db", uid="mike")
sqlTables(channel)
a<-sqlFetch(channel,"AnE")
b<-sqlFetch(channel,"vwAnE")
b<-sqlQuery(channel, paste("select * from vwAnE order by loc, month_val"))
xyplot(N~month_val|LOC,b, type="l")
May 12, 2010
MS SQL access
No Comments »
No comments yet.
RSS feed for comments on this post. TrackBack URL
Leave a comment
You must be logged in to post a comment.