Good Afternoon. I have not used Access since 97, and slowly regaining my confidence in it. I am an advanced Excel user including writing macros, but I want to be able to perform this in Access without having to delete 2000+ records and import them again.
I have a database of employees, both active and terminated. Somehow their termination dates for the term'ed employees went missing. I have them from an excel file.
My excel file is simply setup with two columns, one Labeled Name and the other Term Date. These are the same as the field names in my table called Employee. I have tried linking the new data in a table and running an update query, without success. I have dabbled with DLookup in the Update To: portion of this query.
Is there a simpler way of doing this? I have backed my database up already and open to suggestions. I can provide screenshots if that helps. Thanks!!