Load Data in SQLite from Tabular Files


[Up] [Top]

Documentation for package ‘RSQLite.toolkit’ version 0.1.2

Help Pages

dbCopyTable Copy a table from one SQLite database to another
dbCreatePK Creates a unique index on a table in a SQLite database
dbExecFile Execute SQL statements from a text file
dbTableFromDataFrame Create a table in a SQLite database from a data frame
dbTableFromDSV Create a table from a delimiter separated values (DSV) text file
dbTableFromFeather Create a table from a Feather (Arrow IPC) file
dbTableFromView Create a table in a SQLite database from a view
dbTableFromXlsx Create a table in a SQLite database from an Excel worksheet
error_handler error_handler manage error messages for package
file_schema_dsv Preview the table structure contained in a DSV file.
file_schema_feather Preview the table structure contained in a Feather file.
file_schema_xlsx Preview the structure of a range of an Excel worksheet.
format_column_names Format column names for SQLite
R2SQL_types From R class names to SQLite data types