This example demonstrates how entries can be imported from an Excel file.

 

1) Select the File datasource type:

 

 

2) Select the type of file you wish to import from. In this example, we will import from an Excel file:

 

 

3) Select the Excel file to import from by clicking on the Choose File button. Select the desired file and click Open:

 

 

 

4) Change the text identifier if required, in most instances this can be left as it is:

 

 

5) Opt to either import the data from a Table (sheet), or through a Query:

 

 

6a) If Table is selected, select the Table (sheet) to import from:

 

Then select any filtering options as desired:

 

 

6b) If Query is selected, write the query where prompted. Note that the query is formed as T-SQL, executed through the ACE Driver:

 

 

7) The content of the final step will vary depending on the feature being imported to. It will have the data that is being set listed on the left, and the sheet's columns on the right. By selecting the appropriate column in each instance, the data can be mapped from the selected sheet to the appropriate inputs in Scripting:

 

 

8) Click Finish. You may have to click Close or Save in subsequent pages to complete the process.