[R] R and libre office base

[Marc Schwartz]

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