Rasmus Liland
2021-Nov-10 15:15 UTC
[R] how to connect libreoffice base odb using R package odbc?
Are you willing to send me a part of the the proof.odb so I can run the query? R -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 833 bytes Desc: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20211110/dd500fb3/attachment.sig>
Rasmus Liland
2021-Nov-10 15:57 UTC
[R] how to connect libreoffice base odb using R package odbc?
.... also Note in ?ODB::odb.read says: To query databases built with OpenOffice or LibreOffice, it may be necessary to quote table and/or column names in ?sqlQuery?, as the default behavior of the HSQL engine is to convert unquoted table and column names to uppercases. :) -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 833 bytes Desc: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20211110/c0c659a1/attachment.sig>
Luigi Marongiu
2021-Nov-10 16:05 UTC
[R] how to connect libreoffice base odb using R package odbc?
Sure! I am attaching a simplified version of it. I did not see the quote text; it might be difficult to call all table's names since there are hundreds of columns.. On Wed, Nov 10, 2021 at 4:15 PM Rasmus Liland <jral at posteo.no> wrote:> > Are you willing to send me a part of the > the proof.odb so I can run the query? R-- Best regards, Luigi