Task #6801
closedInstall mdbtools
100%
Description
I need to open an MS Access database from R Studio.
For this, I have this piece of code that is working on my computer (Linux):
library(Hmisc)
path_to_iccat_access_db<-"/home/ptaconet/Bureau/Sardara_R_scripts/OriginalData_TRFMOs/ICCAT_2016_11/CE/t2ce_20161114web.mdb"
t2ce<-mdb.get(path_to_iccat_access_db,tables='t2ce')
The Hmisc library needs mdb-tools to work correctly (as explained here: http://svitsrv25.epfl.ch/R-doc/library/Hmisc/html/mdb.get.html and showed on the attached picture)
Is is possible to install the mdb-tools on the machine?
Regards,
Paul
Files
Updated by Pasquale Pagano about 8 years ago
- Assignee changed from Pasquale Pagano to Andrea Dell'Amico
@andrea.dellamico@isti.cnr.it can you check if we can install the reported tool on RStudio and Data miner instances?
Updated by Andrea Dell'Amico about 8 years ago
- Status changed from New to Feedback
- % Done changed from 0 to 100
I've just added mdbtools and odbc-mdbtools to the list of packages that have to be installed on every dataminer and rstudio server.
They should be already present everywhere, or they will be in the next 10 minutes.
Let me know if it works.
Updated by Andrea Dell'Amico about 8 years ago
- Tracker changed from Support to Task
- Infrastructure Pre-Production added
Updated by Andrea Dell'Amico about 8 years ago
- Status changed from Feedback to Closed