Dear Luigi, I tried quoting ... This:
odb = ODB::odb.open("proof.odb", jarFile = NULL)
dput(sapply(names(ODB::odb.tables(odb)), function(tbl) {
sqlQuery <- paste0('SELECT * FROM "', tbl, '"')
ODB::odb.read(odb, sqlQuery)
}, simplify=F))
ODB::odb.close(odb, write=FALSE)
Yields this:
list(day = structure(list(day_ID = c(0, 1, 2, 3, 4, 5, 6, 7,
8, 9, 10, 11, 12, 13, 14, 15, 16, 17), Day = c(1, 2, 3, 5, 7,
9, 11, 13, 14, 16, 18, 20, 22, 24, 26, 28, 30, 31)), row.names = c(NA,
18L), class = "data.frame"), demographic = structure(list(ID =
logical(0),
Study_ID = logical(0), Hosp_ID = logical(0), Hospital = logical(0),
Address = logical(0), Occ_ID = logical(0), Age = logical(0),
Sex = logical(0)), row.names = c(NA, 0L), class = "data.frame"),
hospitals = structure(list(Hosp_ID = c(0, 1, 2, 3), Hospital =
c("Fatebenefratelli",
"Royal Free", "Santa Croce in Gerusalemme", "Sagrada Familia"
), Address = c("Via Tiberina", "Tottenham Court road", "Via Latina",
"Barcelona")), row.names = c(NA, 4L), class = "data.frame"))
The demographics table is empty, but has
headers .... Maybe you selected the
wrong file ...
Best,
Rasmus
signature.asc
Description: PGP signature
______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.
