Add Custom Table Inserts

The Jet Data Manager allows you to write your own Custom Table InsertsThis gives you more flexibility compared to the Table Inserts feature already available in the product.

To add a custom table insert to a table, perform the following:

1. On the Data tab, in a data warehouse, right-click the table you wish to add the Custom Table Insert to, click Advanced and click Add Custom Table Insert. The Add Custom Table Insert (<table name>) window opens.
2. The editor is similar to other custom code editors in the Jet Data Manager. In the text field, write the SQL SELECT statement that gives you the data you wish to insert into the table. Note: The fields you include in your SELECT statement must exist in the table you are inserting data into. Use AS when the names do not match.
3. In the Destination table list, click the instance of the table you wish to insert the data into. The default is Raw.
4. Click OK.

Note: In the script editor, create a SQL SELECT statement - no INSERT clause is necessary.  The script should look like this:

If the field names in the source tables are different from the field names in the destination table table, use an alias to make the names match up.