Read tables from a DeST model and convert to SQLite

Read tables from a DeST model and convert to SQLite

Usage

read_dest(accdb, tables = NULL, sqlite = ":memory:", verbose = FALSE)

Arguments

accdb

[string] Path to the DeST model file. Usually a Microsoft Access database file with .accdb extension.

tables

[character] Vector of table names to read from the DeST model. If NULL, which is the default, all tables will be read.

sqlite

[string] Path to the SQLite database file. If :memory:, which is the default, a temporary in-memory database will be created.

verbose

[logical] Whether to print information about the conversion process. Default is FALSE.

Value

[DBIConnection] A SQLite database connection with all specified tables..

Note

Tables with the same name will be overwritten in the SQLite database.