INSERT only new records

  • Thread starter Thread starter James Pang \(S'pore\)
  • Start date Start date
J

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
 
Your brother's advice is good, and should be followed. But I don't
understand what problem you're having?
 
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
 
Thanks Ken,

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

Cheers Ken !
 
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.
 
Back
Top