I am wanting to regularly import a "staff" table to an access database and compare it to the current staff table in the database.
What I am hoping to achieve is to compare the current "staff" table with the imported "staff" table and find any differences. The imported table would hold the most up to date data. If there was a difference in any of the fields between the two tables, I would like the current staff table to be updated with the value in the imported table. Also, if there are any new records in the imported table, I would like these to be appended to the current table.
Even if the updates can't be done automatically, if the two tables could be compared to highlight any field(s) that are different and any new records, this would be a good starting point.
Does anyone have any suggestions on the best way to try and tackle this?
Thanks
What I am hoping to achieve is to compare the current "staff" table with the imported "staff" table and find any differences. The imported table would hold the most up to date data. If there was a difference in any of the fields between the two tables, I would like the current staff table to be updated with the value in the imported table. Also, if there are any new records in the imported table, I would like these to be appended to the current table.
Even if the updates can't be done automatically, if the two tables could be compared to highlight any field(s) that are different and any new records, this would be a good starting point.
Does anyone have any suggestions on the best way to try and tackle this?
Thanks