Append data if it doesn't already exist in table

[skwilliams]

I have a linked table "Proof Cycle" to an excel file. I also have an append query to place the data in a permanent table "tblProofCycle". This works fine.

My problem is sometimes the data in the linked file may already exist from a previous append.

I'd like to only append the data into "tblProofCycle" which doesn't already exist.

Any ideas??

Thanks.

 

[mbreu996]

You need someway of uniquely identifying records in your excel table. Once you do this, Access will automatically only add the "new stuff". That is the glory of the append.

Does this make sense?

 

[mbreu996]

I would have to know more about your data to say how to uniquely identify the rows in Excel.