Hi
I am trying to export multiple dataframes from R to MS Access using the ImportExport package. I get "error: JAVA_HOME cannot be determined from the Registry"
I think this may be related to whether my Rstudio and/or R is 32 or 64 bit.
How can I tell if my Rstudio/R is 32 bit or 64 bit plz?
Will getting 64 bit Jva fix this problem?
Thanks
> access_export("DBenrich.mdb",Dfr,Dfr)
Error in access_export("DBenrich.mdb", Dfr, Dfr) :
could not find function "access_export"
> ImportExport::access_export("DBenrich.mdb",Dfr,Dfr)
Error: .onLoad failed in loadNamespace() for 'rJava', details:
call: fun(libname, pkgname)
error: JAVA_HOME cannot be determined from the Registry
> install.packages("rJava", lib="C:/Program Files/R/R-3.4.3/library")
trying URL 'https://cran.rstudio.com/bin/windows/contrib/3.4/rJava_0.9-10.zip'
Content type 'application/zip' length 726859 bytes (709 KB)
downloaded 709 KB
package ‘rJava’ successfully unpacked and MD5 sums checked
The downloaded binary packages are in
> ImportExport::access_export("DBenrich.mdb",Dfr,Dfr)
Error: .onLoad failed in loadNamespace() for 'rJava', details:
call: fun(libname, pkgname)
error: JAVA_HOME cannot be determined from the Registry