adm_worksheet_to_db: Process worksheet from Excel file to write to SQL Server...

In thomascrines/admStructuredData: Upload Excel Workbooks to SDR

Description

adm_worksheet_to_db writes an Excel worksheet to a SQL Server database.

Usage

adm_worksheet_to_db(
  database,
  server,
  file_path,
  worksheet,
  overwrite = FALSE,
  append = FALSE
)

Arguments

database	string. The name of the database to write the sheet to.
server	string. The name of the server containing the database.
file_path	string. The full path of the file containing the worksheet.
worksheet	string. The name of the worksheet to be processed.
overwrite	string. Default: false. Whether to overwrite existing table with worksheet with the same name.
append	string. Default: false. Whether to append worksheet to existing table with the same name.

Value

null

Examples

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

## End(Not run)

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