We have a database in Access that is split into a front end and back end. Occasionally, our sister company will make changes to the data in their copy of some tables and send them to us. We need to compare the two tables to find any differences and highlight them. Then if the changes are acceptable a button on the form will update our copy of the table. The source table has about 35 columns and 5000 rows. There are two different tables that need to be compared.
The tool needs to be general-purpose and able to compare any two tables and display the original on one line and the update data on the next row. Any differences should be highlighted in the second row. The form would show one row at a time, only where there is/are a difference, and show the complete record for both the original and update file.
A separate project will be posted for a validation
27 pekerja bebas membida secara purata $190 untuk pekerjaan ini
Good day, I am an expert MS Access data table comparison tool I can start working immediately if you give me a go !!! ★★ MY EXPERTISE ★★ Visual Basic SQL Microsoft Access Database Programming
Hi There, Is it possible to modify the structure of the source table? I am a seasoned DBA with background knowledge of different DBMS and SQL queries. Looking forward to hearing from you, Best regards