Manage Primary Keys
Please, review articles in this topic, if you are working with Database data. It describes how to manage Primary Keys in xlCompare.
What is Primary Key?
Primary Key is unique value in the database table, which identifies record. Typically Primaary Key is stored in a single column in the form of numeric value. But, your table may have complex key, which consists of several columns.
xlCompare supports all types of the Primary Keys and give you set of commands to define and highlight key columns and rows on your worksheet.
Why this is important?
Database Table and Excel Worksheet with formulas, require different algorithms to compare. Database Records must be sorted and compared by Primary Key. While Excel Worksheet should use other comparison strategies.
For additional information, please visit this page Manage Primary Keys.