Displaying 1 result from an estimated 1 matches for "msysqueries".
2004 Nov 02
2
A little more on R, mdbtools and Access databases
...ubsets of columns and rows)
Here is an example session using a database I found on the web at
http://www.microsoft-accesssolutions.co.uk/downloads/login.zip
> db <- "/home/dave/tmp/login.mdb"
> mdbTables(db)
[1] "MSysObjects" "MSysACEs" "MSysQueries"
[4] "MSysRelationships" "MSysAccessObjects" "tblEmployees"
> mytab <- mdbTables(db)[6]
> mytab
[1] "tblEmployees"
> x <- mdbReadTable(db, mytab)
> str(x)
`data.frame': 4 obs. of 4 variables:
$ lngEmpID : int 1 2...