You can't use this until you register with us!

Description

Obtain data from Excel Spreadsheets stored in OneDrive and load it into an SQL Server database.

Purchasing Options

Excel Spreadsheet Loader - OneDrive to SQL Server - $99.99 / month

Available Actions

Load Data

Read data from Excel Spreadsheets and store it in an SQL Server database.

Variables

Source Parameters
microsoft_connection required

Credentials to use to access the OneDrive folder containing the Excel spreadsheets.

user_id

ID of the user that owns the OneDrive location where the spreadsheets to load exist.

email

Optional. Only needed if User ID is not specified. E-mail address of the user that owns the OneDrive location where the spreadsheets to load exist.

target_folder_name required

Path to the folder in OneDrive where the Excel spreadsheets are stored.

process_subfolders required

If enabled, data in Excel spreadsheets within subfolders under the folder specified in the Folder Path will also be read and loaded.

filename_mask

RegEx pattern for selecting which files to load. Specify .* for all files.

file_lookback

Specify the number of load records to examine, from most recent and going backwards, when comparing to determine which files have not yet been loaded. If no value is specified, all load records will be examined.

sheet_name

Optionally specify a unique name to use to locate the sheet to load.


Destination Parameters
db_connection required

SQL Server database where the data from the Excel spreadsheets will be loaded.

target_table_name required

Table name, in schema.table format, where the data from the Excel spreadsheets will be stored.

source_file_column required

Column within the Target Table where the path to the spreadsheet that was the source of the data will be stored.

header_row required

Enable if the Excel spreadsheets contain a header row.

mappings required

Mappings between the columns in the Excel spreadsheet and the columns in the Target Table.