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, below is a crude list of loans, which is basically the format of my actual data.
Let's call this List A, the existing database that I have. Now, I have another list - List B - which contains the first 5 loans as well as 2 new ones and some updates on the existing loans.
I need to update my existing database (List A) so that it would reflect the changes in the new database (List B). For the two new entries, I know I can just import them so that's my first problem solved. However, I cannot import Loans B, D and E, as that would duplicate my existing entries. I just need to update their amounts. I thought about using Update Query, but as far as I know, that requires a specific criterion to be updated to a specific value also (e.g., change all 0 to 1).
Lastly, I have a third list (List C) that also reflects a different update. In this case, some of the loans are already paid for so I need to remove them from the database altogether without having to delete them one by one.
Usually, these lists are provided on different dates (otherwise, I would just use the latest list instead of going through each of them). Also, there are thousands of data involved so manually updating them is out of the question.
Is this possible in MS Access?
Thanks for the help! I hope it wasn't too confusing hehe.
3 Replies
To be honest, I find it a bit confusing. Am I right in concluding that:
- List B is a list of all current loans including recent additions and updates?
- List C is a list of all current loans, no longer including recently fully paid loans?
If so it can be done. The number 2 requirement can also be done.
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.
