read.db: Read a Data File into an SQLite Data Table.

Description Usage Arguments Value Author(s) See Also

View source: R/read.db.R

Description

Read data from a delimited data file into a SQLite data table using the dbWriteTable function.

Usage

1
read.db(file, dsname, database=paste(dsname, ".db", sep = ""), header = TRUE, ...)

Arguments

file

quoted name of the file in which the data reside. The data should be in a form acceptable to dbWriteTable.

dsname

quoted name of the data table to be created.

database

quoted name of the database file in which the data table is to be stored; if missing, a file named dsname.db (where “dsname” is the dsname argument) will be created in the current directory and the data table will be written there.

header

does the first row of the data file contain variable names (default, TRUE)?

...

argument to be passed to dbWriteTable.

Value

TRUE if the operation succeeded; FALSE if it failed.

Author(s)

John Fox, jfor@mcmaster.ca.

See Also

dbWriteTable, sqliteImportFile, SQLiteDataset


dfdb documentation built on May 2, 2019, 4:58 p.m.

Related to read.db in dfdb...