UQT has a Data Loader that allows you load data into your tables. Data can come from:
The Mapping panel allows you to specify how your data is transformed from load source to the table you are loading
In this example (see Load Spec)
You can do a Preview of the load. This will show you how the data will be loaded into your table, prior to doing the load.
"Obvious" errors, such as numeric value not numeric, or character value too long, will be highlighted