Hi

I would like to know how to import an excel worksheet into Access base on data changes. I am exporting data from global ticketing solution to excel on a weekly basis based on Region and modified date.
I want to then merge changes to a local database.
If a ticket (row) has been modified replace the old entire row in the local database, if its new just add the entire row to the data base.

I have a primary key for each row which never changes. This is the ticket number.
Is it possible to compare the two values in Excel and the Access Database and if match then compare the date field in that row.
If date is newer overwrite the entire row in the database. (Not sure if the date format is going to be an issue?)
Below is the sample fields, Incident ID+ is the key unique field and the last modified date is the comparison field.



Incident ID*+ Priority* Incident Type* Status* Resolution Last Modified Date
INC000001247345 Medium User Service Request Assigned Token synchronization 5/22/2013 3:01:28 PM

Lastly if a new Incident ID is found it just adds it regardless of the date.

Hope this is clear.
I am using Excel and Access 2010