A wrapper for a system call to the bcp utility which bulk inserts to SQL Server.
dataframe object or path to file
named list of connection arguments. See makeConnectArgs.
Name of the source table when importing from SQL Server. For specifying the
schema in the table name see
<schema>.<table> and if not specified the
default is "dbo".
character separator for columns
character separator for rows--new lines
Whether to overwrite the table if it exists
spatial data type for schema
x is not an 'sf' object
list of additional options to pass to the 'bcp' utility. See details.
arguments to pass to system2
... to redirect output.
If x is a dataframe object,
data.table::fwrite is used to write the
in memory object to disk in a temporary file that is deleted when the
function exits. The
ignored in this case.
TRUE, any existing table of the same name
will be deleted and the schema is inferred from
use a customized schema, create the schema before calling the function and
If x is a sf object, the geometry column is converted to binary and written to the database before conversion to geometry/geometry data type. The EPSG code is automatically read from the sf object and used as the SRID.
To override the default path to the bcp command line utility, set the
To override the default path to the sqlcmd command line utility, set the
bcpOptions allows the user to include additional arguments for the
system2. Please refer to
The default options are set to the defaults for
refers to number of rows to write at a time; 10,000 to 50,000 is a
-a refers to size of packets to be sent in
-e refers to the maximum number of errors before failure.