Hi,
On a monthly basis, I get an excel file that I need to upload to access.
My primary key is called "Work order". The two relevant fields I am concerned with relate to the work order creation date and work order closure date. The data will always be populated for the "Date created" field, but there will not be anything populated in the date closed field until the physical work is completed.
So, from month to month, the excel file I receive will have a lot of the same work order numbers on it.
What I am trying to do, is upload the excel file to my existing table and overwrite any records that have been modified (IE records that should now have the date closed).
Simply using the upload from excel to existing table does not work, it treats the already created records with missing date closed fields
I have seen other posts that suggest you need to upload the data to a new table, set a relationship between these tables, create a mismatch query, then an update query. This seems like a lot of work and I'll be honest it pushes the limits of my access knowledge. I am hoping a guru may have a simpler solution!
Thanks a ton in advance for taking the time to read this.