search for: myaccessdb

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 JJ -- Lecturer J. Joshua Thomas KDU College Penang Campus Research Student, University Sains Malaysia -- Lecturer J. Joshua Thomas KDU College Penang Campus Research Student, University Sains Malaysia [[alternative HTML version deleted]]

...bls), function(.i){ .d <- try(get.table(.tbls[.i], db = db)) return(invisible(.d)) }) names(.d) <- .tbls .ok <- !sapply(.d, inherits, "try-error") return(list(notdone = .d[!.ok], data = .d[.ok])) } library(RODBC) alldata <- get.alltables(db = "./myaccessdb.MDB") ## code end