how to update a normal table from an excel linked table

[Ryno Bower]

Hello Guys
I have a linked excel sheet to MsAccess 2007.* In order to make extra changes to the information, I have to make a normal table in access.* Then add fields so it can be modified, as I cant modify or change anything in the linked sheet.
Is there a way to update WipMasterTbl from the linked excel table "WipMaster" and only add new records that are not in the table "WipMasterTbl " and also change the values if the excel sheet has changed.
I've tried the update query but I dont get it to work.* If I append then it adds all the records again!
Please Help
Ryno

[NeoPa]

It's not clear if this question is about using data from an Excel Linked table or how to manipulate data in a database.

I suggest the first thing you should do is to append the data from Excel into a local Access table if you're unsure about the limitations of a linked table.

As far as data manipulation is concerned, it is the same as you would expect to do in a database. Appending data is done using an APPEND query, and updating is done in an UPDATE query. Your WHERE clause can be used to ensure that the append data only is applied in the APPEND query and the same is true for the data required in the UPDATE query. There is no facility to do both steps within the same query.