I would like to update records to the deceased section in access from a excel spreadsheet.
I have a access dbase with patient #, name, and a deceased date. The Excel spreadsheet is setup the same way. Every month I get a excel deceased spreadsheet. How can I add the date of death from the excel spreadsheet to my access deceased date section? Please help I just manually typed in over 200 deceased dates. I'm using Access 2003