Import Records Problems

[AlanP]

Hi everyone...have an issue I just can't seem to find an answer for:

In our database we have a table that has the employees 'employment' history (department, area, etc.). In the main table/layout this is viewed as a portal (we keep a running history).

Our human resources area provides an excel list with the employees CURRENT assignment.

Now when I try to do an import from their excel list I can never seem to achieve this:

- I want to import and if the employees assignment has changed (based on the table and the excel file) it will add a new record with the new assignment.

So far this does not work in all the ways I've tried....has anyone had experience doing this? It would save LOTS of time for us!

We do not want a new record added if the employee is in the same assignment.

--- Here is what it does during import based on different import methods ---

1) Adds a new record every time (with the assignment) regardless of it is the same assignment or new.

2) Adds multiple records of the same assignment

etc.

Thanks!

[comment]

You could import the excel to a temp table. Define a relationship between the temp table and your history, matching employee AND assignment. Then find the records in the temp table that do NOT have a related record, and import only those.

[AlanP]

Thanks Comment!

Sorry to sound naive...how should I go about doing this? I understand how to do the import into a new table but not sure how to do the matching of employee and assignment. Is this through a script or calculation or am I way off?

[comment]

You need to define a relationship between the two tables.