LoadExcelFile

LoadExcelFile operation loads one or several sheets from a Microsoft Excel file.

• Source - name of any file-based source
• Space - path to the file in the source (e.g. C:\Users\john\reports\)
• Table - name of Excel file (e.g. end-of-month.xlsx)
• Select sheets to load - one or more names of table of query in the Excel file. Use the suggest list to pick from.
• Target Source - name of the target source, e.g. a relational database system
• Target Space - name of the target space
• Target Table Name Prefix - name of the result table is this prefix concatenated with the name of Excel sheet specified in Select Access tables/queries. For example: excel_load_.