Forum Discussion
Updating a DB using a running file
Hi! So, I have a database of unpaid loans. And I need to update this database to 1) add new loans; 2) update partially paid loans; and 3) remove fully paid loans. To simplify my illustration,...
Sorry about that. Basically, these lists come from a bigger database to which I do not have any access. As such, I am only provided a streamlined version. As the bigger database is updated daily, I also receive a streamlined version on day-to-day basis. That is why Lists B and C appear to be similar to List A, but List A is the list that is in my database. I have to update it based on the data found in the succeeding lists as it comes.
List A was sent to me Day 1. List B is Day 2, and List C is Day 3.
Hope that clarifies things.
If all lists are lists of all current loans, I see no reason why you should not just use the most recent list.