Import CSV to tabel, but only new data

[Keeperen]

Hello,

I have a production machine that writes its output to a CSV file every time it produces a good part (several times pr. day). It can produce identical part which means that the mashine will not put in another line in the csv, but just update the no of produced parts. I had to rename the attached file because you can not uploade *.csv files in the forum.

What I want is:
- When someone opens a specific Access db a tabel in the db is updated with all new data from the csv file.
My problem is: How do I make sure that I only get the new data from the Access db.

Please note that I'm a rookie in Access and would like to keep it simpel.....if possible

In advance thanks.

Allan

 

[gemma-the-husky]

i find the easiest way is to import the data to a temporary table, then compare it with the current data, and then mange new or changed data

or yuo can do this by linking to the spreadsheet.