Project

General

Profile

Actions

Task #6801

closed

Install mdbtools

Added by Paul Taconet about 8 years ago. Updated about 8 years ago.

Status:
Closed
Priority:
Normal
Category:
-
Target version:
Start date:
Feb 02, 2017
Due date:
% Done:

100%

Estimated time:
Infrastructure:
Development, Pre-Production, Production

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

Capture du 2017-02-02 09_48_45.png (247 KB) Capture du 2017-02-02 09_48_45.png Paul Taconet, Feb 02, 2017 09:49 AM
Actions #1

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?

Actions #2

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.

Actions #3

Updated by Andrea Dell'Amico about 8 years ago

  • Tracker changed from Support to Task
  • Infrastructure Pre-Production added
Actions #4

Updated by Andrea Dell'Amico about 8 years ago

  • Status changed from Feedback to Closed
Actions

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 8.91 MB)