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

Attachment: 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.

Reply via email to