Hi everyone, this is a great site and it has been very helpful, but I'm not sure I am tackling my problem the right way. I'd appreciate any insights.
I have a database of insurance payments which is separated by object type(advisor, Policy, Payment, Customer etc). I import a .csv file into a temporary table which is effectively a list of payments. I now want to find a way to make sure that each customer, policy, and advisor mentioned in this temporary table is also in my main database, and put them in if they are not.
After this is done, I want to put each payment into the payment table, using the primary keys of the Advisor, Policy etc tables.
How would you, the wise access programmers of the world, tackle this. I am currently looping through many times in vba, but it seems to take an age, and that is only for the duplicate checking.
Thanks for any help
I have a database of insurance payments which is separated by object type(advisor, Policy, Payment, Customer etc). I import a .csv file into a temporary table which is effectively a list of payments. I now want to find a way to make sure that each customer, policy, and advisor mentioned in this temporary table is also in my main database, and put them in if they are not.
After this is done, I want to put each payment into the payment table, using the primary keys of the Advisor, Policy etc tables.
How would you, the wise access programmers of the world, tackle this. I am currently looping through many times in vba, but it seems to take an age, and that is only for the duplicate checking.
Thanks for any help