odbc_insert: Append a data.frame to a table through an ODBC connection

In inbo/n2khelper: Auxiliary Functions for the Analysis and Reporting of the Natura 2000 Monitoring

Append a data.frame to a table through an ODBC connection

Description

Append a data.frame to a table through an ODBC connection

Usage

odbc_insert(
  data,
  table,
  channel,
  schema = "dbo",
  append = TRUE,
  rows_at_time = 1000
)

Arguments

data	the data.frame
table	The name of the table
channel	the open dplyr connection to the database.
schema	The schema of the table. Defaults to public
append	Append the data or overwrite existing rows?
rows_at_time	Number of rows to insert in one SQL statement

Value

The status of the SQL INSERT for each row in returned but invisible.

inbo/n2khelper documentation built on March 26, 2022, 1:51 p.m.