Displaying 1 result from an estimated 1 matches for "mdbdescribe".
2004 Nov 02
2
A little more on R, mdbtools and Access databases
...ls "Admin","User": 1 2 2 2
> head(x)
lngEmpID strEmpName strEmpPassword strAccess
1 1 Graham graham Admin
2 2 Gavin gavin User
3 3 Lynne lynne User
4 4 David david User
> mdbDescribe(db, mytab)
ColumnName Type Size
1 lngEmpID Long Integer 4
2 strEmpName Text 20
3 strEmpPassword Text 20
4 strAccess Text 40
> mdbQuery(db, "select lngEmpID, strAccess FROM tblEmployees where lngEmpID < 3")
lngEmpID str...