New to Access 2013 - Need help updating database using excel import
Posted on 2015-01-06
I am trying to learn Access (newbie here), so please answer as if answering a newbie.
(Access Table with updates from Excel)
My current table has about 15 columns, my "key" is "APP ID", but when I want to update my database all the other columns could change.
Here are some of the columns I am using:
APP ID (Key)
Every day I need to update this table. There are always completely APP ID's, but there are also changes to old ones.
App ID "1" may change it's status from open to closed, the group may change from Tier 1 to Tier 2.
How do I update the old record in a database?
What I would like to do is find the duplicates and rewrite the old data with the new data, and ultimately end up with one table with the most up to date data.
Thanks in advance for your help.