Skip to main content

Database Validation using an Excel spreadsheet


QAID # 9164 Published

Question / Problem:

How can I utilize Kofax Capture's Database Validation feature using an Excel spreadsheet?

Answer / Solution:

  1. In Excel, create a range using the columns from the worksheet to be used in the validation. Select the columns (A, B, C, etc.) and then click Insert ¦ Name ¦ Define... .
  2. Enter a unique name in the 'Names in workbook' field. Verify that the 'Refers To' field contains the columns that you selected. Note: If you select a name already on the list, the 'Refers To' column will automatically change to the currently configured cells for that range. Make sure that you modify the range before clicking OK.
  3. Click OK when done.
  4. Save the workbook.
  5. Configure an ODBC data source using the spreadsheet.
  6. Configure Kofax Capture's Database Validation as normal. The range name becomes the table name used in Kofax Capture. The columns that make up this range will be the fields validated against.

Applies to:

Product Version