make_ramlegacy: Make a local sqlite3 database with the RAM Legacy Stock Stock...

In seananderson/ramlegacy: Download and Cache the RAM Legacy Stock Assessment Database

Description

Downloads the latest Microsoft Access version (currently version 3.0) of the RAM Legacy Stock Stock Assessment Database from http://ramlegacy.org and converts the database to a local sqlite3 database named ramlegacy.sqlite3. As a byproduct, .csv versions of each table are left in the working directory. Note that you must have the utility mdb-tables installed and in your path. You can find installation instructions at http://mdbtools.sourceforge.net. If you're on OS X and using homebrew, you can install it with brew install mdbtools.

Usage

make_ramlegacy(zip_file = "RLSADB_v4.3_(assessment_data_only)_access.zip",
  acc_file = "RLSADB_v4.3_(assessment_data_only).accdb")

Arguments

zip_file	Name of the Access .zip file you'd like to download from http://ramlegacy.org
acc_file	Name of the Access .accdb file inside the zip file you'd like to download from http://ramlegacy.org.

Value

A sqlite3 database named ramlegacy.sqlite3 and .csv files named after each table in the database.

Examples

## Not run: 
make_ramlegacy()

## End(Not run)

seananderson/ramlegacy documentation built on May 12, 2020, 11:41 a.m.