❖Data can be brought into your model with script that you specify or by simply copying out a sheet of data from an Excel spreadsheet and then pasting it in.
For example, here is some script that brings in data from my Customers Table from an Excel spreadsheet; it actually loads it from the workbook in the folder that my Model file is in:
❖Your data imports from external sources are typically specified in Action Scripts (see Action Script section).
❖To paste in data to a Table, simply copy out the spreadsheet from your Excel workbook, then right click on the Tables node or Objects node and select Paste Table, the table, its column headers and column types will be automatically picked up and added as a new Table for you:
Enter in the Table name and the Separator (in Excel this is tabs), and Guess Rows is the number of rows it will go through in your data to determine the column type, 1000 rows will be fine for me; then click OK:
And your Table is added:
