Compare can also be used to append and update records from an Imported Excel file.
Click on image to view
How Compare works:
Compare stops at the first difference found and displays records with differences.
If differences are found the command buttons can be used to update the Destination table.
To find more differences the user must first reconcile the displayed differences.
If you would like to review the differences without changing any data in the Parts table you can Swap Tables and select Compare.
If you update the Imported table no changes are made to the Imported Excel file. The changes are only made to a temporary Imported table.
That's It !
How Compare works:
Compare stops at the first difference found and displays records with differences.
If differences are found the command buttons can be used to update the Destination table.
To find more differences the user must first reconcile the displayed differences.
If you would like to review the differences without changing any data in the Parts table you can Swap Tables and select Compare.
If you update the Imported table no changes are made to the Imported Excel file. The changes are only made to a temporary Imported table.
That's It !
No comments:
Post a Comment