Update different records in a Linked Table

[Lorlai]

I have an access 2007 table that is linked to a sharepoint site. This table contains data that is imported in from a weekly report. The data may change for each record (Product status may go from great one week to critical the next), and there may be new records that will need to be added. At the moment, all I can figure out is to completly delete the table data and start over, but can no longer do this as a user on the sharepoint site can update the information via the sharepoint. Such changes need to be maintained.

Does anyone have any advice on how to do this? How can I update the record if there is new information?

Thank you!

[June7]

Run two SQL actions. One to update existing and one to add new records.

[Lorlai]

Thanks for responding June7, I appreciate your help.

I have pretty limited experience with SQL, and am not sure how to create an update statement when I do not know the data that will be updated. The examples I can find of an update statement is like this:

UPDATE Customers SET Areacode = "765" WHERE Zipcode="46135"

How would I apply this if I didn't know if it would need to be updated? Like if the CustomerID, CustomerName, CustomerStreet were all the same, it was just the Zipcode that was wrong and needed to be updated based on the incoming data?

Thank you!

[June7]

Somehow would have to detect which value is changed and construct the SQL statement appropriately. That, or just update every field even if nothing actually changed. How many fields are involved?

Seems this is not really an Access question, but a web design issue. I have never used Sharepoint.