Clear a Database Table

Source: R/main.R

Deletes all the rows of the table \(tbl\). This function performs opening of the connection, clearing of the table and closing of the connection. If an error occurs the program stops and an error description is shown.

hsClearTable(mdb, tbl, cond = TRUE, ...)

Arguments

mdb

full path to MS Access database (*.mdb).
tbl

table name.
cond

optional: condition.
...

additional arguments passed to hsSqlQuery, e.g. "errors=TRUE"

See also

hsDropTable