Append table with only new data from linked excel table

[grantc]

I have an existing packing slip access app that works really well, however I am wanting to update/append the stock inventory table from a linked excel table [excel data may change from time to time], but I only want to add new records from the excel table. I tried using an append query but the number it wants to add thousands of rows every time I run it,

Is there a faster method of only appending records from the excel table that don't already exist in the stock table?

Thanks

 

[PWise]

but I only want to add new records from the excel table

What qualifies as a new record?

 

[grantc]

Hi

A new record is a StockCode [part number] that doesn't exist in stock table

i.e
tblStock
[StockID] - Autonumber
[StockCode]
[StockDescription]


tblExcelStock
[StockCode]
[StockDescription]

I only want to append tblstock with entries from tblExcelStock that don't already exist. [StockCode]is the field being used to compare for new records.

 

[PWise]

INSERT INTO MyAccessTable ( field1, field2, field3..... )
SELECT field1, field2, field3.....
FROM linkedexcelltable
left JOIN MyAccessTable ON MyAccessTable.StockCode = linkedexcelltable.StockCode
WHERE (((MyAccessTable.StockCode) Is Null));

 

[grantc]

Thanks that worked!