[R] how to connect libreoffice base odb using R package odbc?

Rasmus Liland jr@| @end|ng |rom po@teo@no
Wed Nov 10 15:43:12 CET 2021


Dear Luigi,

I found the package ODB

	https://cran.r-project.org/web/packages/ODB/ODB.pdf

and was able to install it after 
reconfiguring rJava ...  

The help page ?ODB::odb.open has this 
example:

	odbFile <- tempfile(fileext=".odb")
	odb.create(odbFile, overwrite="do")
	odb <- odb.open(odbFile)
	
	# New table
	odb.write(odb, "CREATE TABLE fruits (name VARCHAR(6) PRIMARY KEY)")
	odb.insert(odb, "fruits", c("banana", "pear", "peach"))
	
	# Writes to the file and closes the connection
	odb.close(odb, write=TRUE)

Best,
Rasmus

-------------- 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/8bea907b/attachment.sig>


More information about the R-help mailing list