Compare Data

[Dava Sutts]

Hi

I have my main table in my database with the following fields:

Name; Status; ID etc etc

I produce an Excel Download from Business Objects to get this data and from
this i have 2 scenarios in which i was hoping could be automated?

1. I could have new entries ie a new Name, Status, ID or

2. The Status of current records in the table could change from eg. Testing
to Operation

Is there anyway i could import the new data and compare it with the current
contents of my Main Table to add new records and also update the change in
Status?

Thanks
Dave