INSERT only new records

[James Pang \(S'pore\)]

Dear Reader,

Currently i am able to import the data into the destinated
table.

As the source data file can grow in size. I only wants
those <<additional data>> to be INSERT into the table.

A brother of mine, John, has taught me to store the
imported data @ a temp. table (After that) I make a APPEND
QUERY to INSERT the new data into the "destinated table".
(And the above problem still can't be resolved)

Pls Acknowledge! Thanks

 

[Ken Snell]

Your brother's advice is good, and should be followed. But I don't
understand what problem you're having?

 

[James Pang]

Scenario:
To import the Revenue figures(from Excel) into "Revenue"
Table (in Database)

PROBLEM: At the "First" Import data will flow in fine.
and ........
(When there is 'new' data at Revenue(Excel))
The "2nd Import" will stack onto the previous data(in
Database).
*****************************************************
I just need the 'new' data w/o the previous one i did at
the "First" Import
*****************************************************

For instance:
I've 90 transactions now....i imported it....
while it becomes 110 transaction.....i should have 110
instead of 200 !!


Thanks Brother, Ken, for you reply!
Waiting to hear from you soon~

Take care, Cheers !
Regards, James

 

[James \(Thank you\)]

Thanks Ken,

A guru named , John Nurick, solved my problem!
You must know this guy man.

Cheers Ken !

 

[annon]

you dont say how you are going to use the data, but sounds like using the append function will only add new records, which sounds like what you want.

a simpler route (besides temp table) is to create a new link table in access, which creates a virtual table in access that has a dynamic link to the excel table. then, write a query to extract whatever data you want. you may have to use a key in your source excel table, so only records with a key not already in your destination table will be appended.