How to create a custom table insert

TimeXtender has a feature called Custom Table Insert. This feature allows user to add data to a table based on a custom SQL query

To use this feature, right-click the table you want to add data to, select Advanced, and then select Add Custom Table Insert.




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

[FullName] AS [Full Name]
FROM [Person]

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.

Was this article helpful?
3 out of 3 found this helpful


  • 4
    Stuart Cuthbertson

    It would be great if this could be added to the main PDF User Guide :) 

Please sign in to leave a comment.