On May 17, 2013, at 9:47 AM, Johan Lassen <johanlassen at gmail.com>
wrote:
> Dear community . I would like to connect r to libre office base. Does
> anyone know if and how this can be done? I think of the pendant to rodbc
> for libre office. I am using windows 7.
> Thanks in advance and best regards johan
As an FYI, there is an R list just for database access related issues:
https://stat.ethz.ch/mailman/listinfo/r-sig-db
Both OpenOffice and LibreOffice use HSQLDB, which is a java based database.
There are no ODBC connections supported by HSQLDB. However, I believe that some
have had success with JDBC and there is the ODB package on CRAN
(http://cran.r-project.org/web/packages/ODB/).
Regards,
Marc Schwartz