adm_folder_to_db: Upload all Excel worksheets in a folder to SDR

In thomascrines/admStructuredData: Upload Excel Workbooks to SDR

Description

adm_folder_to_db uploads all worksheets in all Excel workbooks in a specified location to a specified database. Processed folders are then moved from the source folder to an archive folder.

Usage

adm_folder_to_db(
  database,
  server,
  source,
  append = FALSE,
  overwrite = FALSE,
  archive = NULL
)

Arguments

database	string. The database to write the data to.
server	string. The server holding the database.
source	string. The path of the directory containing Excel files.
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. The path of the directory to send processed files to.

Value

null

Examples

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

## End(Not run)
## Not run: 
adm_folder_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.