The Jet Data Manager allows you to write your own Custom Table Inserts. This gives you more flexibility compared to the Table Inserts feature already available in the product.
Adding a Custom Table Insert
To add a Custom Table Insert to a table, follow the steps below.
- On the Data tab, in a data warehouse, right click on the table you wish to add the Custom Table Insert to, click on Advanced and click on Add Custom Table Insert. The Add Custom Table Insert (<table name>) window opens.
- 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.
- In the Destination table list, click on the instance of the table you wish to insert the data into. The default is Raw.
- Click on 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.