I have a ACCESS 2002 Db and an excel document with these same fields on them.
SSN NAME DateofLetter 35dayexpire Address DateofBirth Enrollcode Enrolleffdate Indefinite
Continue Terminate CaseClosed
I want to have the excel records that I am going to upload into the database look and if there is an existing record (looking at the SSN field) in the DB then I want it to update these fields (Indefinite Continue Terminate CaseClosed) to match what is already in the DB.
If there is not an existing record (looking at the SSN field) in the DB then I want those fields to be FALSE.
Is there any way for this to be an automatic process so I don’t have to compare the Database and the Excel Document manually?
