I'm importing a worked hours dataset from Excel every 30 minutes and need to find new Employee and Job records within the dataset. The Employees and Jobs also have unique ID's which I suppose should make it easier.
I thought I could somehow compare the newly uploaded data to the Employee table using the unique ID and find those records in the new data that don't have a corresponding record in the Employee table? I also thought this would be easy ... I tried a 'not equal' join between the ID field in the Employee table and new data Employee ID field and expected a list of data for Employees not in Employee table?
Any thoughts? I'd be very grateful?
Thanks in advance,