ODBCFace can run multiple queries against multiple data providers and posting the results in different tabs or areas of your workbook.
A very simple validation technique could involve downloading the validation table (i. e. an UDC table in J. D. Edwards) in a separate tab.
The use of a simple Excel MATCH formula could validate the data.
ODBCFace is also capable of conditioning the execution of subsequent statements, based on the content of a row, therefore providing a way of avoiding execution for data not validated (look for the keyword If in the User's Guide).
A more complex approach could involve nesting SQL statements as explained in How do I perform a database lookup?