Write data.frame to database using bcp
1 2 3 4 |
data |
data.frame to be written to database. Column names must match with those in the database table. |
table |
character string naming the table to write to. Can include database and schema name (database_name.schema_name.table_name). |
conn |
RODBC connection object as returned by db_connect(). Optional, but allows to re-use an already open connection to check columns and truncate table (if |
truncate |
logical. If |
preserve_empty_strings |
logical. If |
sep |
character string to use as column separater when writing the data file passed to the bcp utility. Make sure this string does not exist in the data. |
eol |
character string to use as end of line separater when writing the data file passed to the bcp utility. Make sure this string does not exist in the data. |
paranoid |
logical. If |
preserve_memory |
logical. If |
tmp_dir |
character string |
tmp_keep_files |
logical |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.