Create the spreadsheet based on the spreadsheet template in the following Data Validation Option installation directory:
<Data Validation Option installation directory>\samples\CompareTables-template.xlsx
Define table pairs in the first worksheet. Data Validation Option ignores other worksheets in the Excel workbook.
The Excel file must have a .xls or .xlsx file extension.
You must enter values in the LEFT_TABLE and RIGHT_TABLE columns.
The column names are not case sensitive.
If you create a joined table pair, you must specify a column name in the Join_A and Join_B columns. To enter an expression for the join field, generate the table pair and then edit the join field in the table pair.
You cannot specify an XML file as a table in the spreadsheet.
If you import a table pair from a spreadsheet and the table pair is based on the same tables as an existing table pair, Data Validation Option creates a duplicate version of the table pair with the same name.