Define tests in the first worksheet of an Excel workbook. Data Validation Option reads the first worksheet and ignores other worksheets in an Excel workbook.
The Excel file must have a .xls or .xlsx file extension.
To define tests for multiple single-table constraints, define tests for each single-table constraint in a separate Excel workbook.
You can only define one test per row.
You must specify a field name or a field expression for each table in each row of the spreadsheet. If you specify a field name and field expression for the same table in a row, Data Validation Option uses the expression.
If you select an operator that is not valid for a particular datatype and you try to import the tests from the spreadsheet, Data Validation Option displays an error.
The values in the spreadsheet are case sensitive.