adm_workbook_to_db: Process files to write to SQL Server database

In thomascrines/admStructuredData: Upload Excel Workbooks to SDR

Description

adm_workbook_to_db writes all worksheets in an Excel workbook to a SQL Server database.

Usage

adm_workbook_to_db(
  database,
  server,
  file_path,
  append = FALSE,
  overwrite = FALSE,
  archive = NULL
)

Arguments

database	string. The name of the database to write the file to.
server	string. The name of the server containing the database.
file_path	string. The full path of the file to process.
append	string. Default: false. Whether to append worksheets to existing tables with the same name.
overwrite	string. Default: false. Whether to overwrite existing tables with worksheets with the same name.
archive	string. Optional. The path of the directory to move the processed file to.

Value

null

Examples

## Not run: 
adm_workbook_to_db(database = "DatabaseName", server = "ServerName\\Instance", file_path = "C:\\Temp\\ExcelFile.xlsx")

## End(Not run)
## Not run: 
adm_workbook_to_db(database = "DatabaseName", server = "ServerName\\Instance"file_path = "C:\\Temp\\ExcelFile.xlsx", archive = "C:\\ArchiveFolder\\")

## End(Not run)

thomascrines/admStructuredData documentation built on March 5, 2020, 3:20 a.m.