Filtering Out Duplicates while updating Table

[DDONNI]

Hey Guys, I'm having some problems as i'm kind of a beginner to using access i'm used to using MySQL, but this one has me stumped. I have a table that i update weekly, and theres around 100 or 200 hundred new entries, I download the data into an excel sheet format it and import it into Access. But the data isn't always uniqu there could be some entries from the previous week in the new upload. I was wondering if theres a way to filter out those duplicates. Unfortunately theres no column that is unique, its only the entire row put together that makes it unique. e.g.

Original Table
1234 10 15 1
1234 20 15 2
1234 30 15 3
1235 10 25 1
1235 20 40 5
1235 30 24 8
1235 40 12 1

Then i update the following data

1234 10 15 1
1235 40 12 1
1245 10 30 2
1245 20 24 4
1245 30 23 6

The first 2 entries already already exist in the tablebut the last 3 don't so i only want the last 3 to be updated.

Could anyone help me on this one please, i'm sure theres an easy answer to this its just i can't seem to work it out.

Cheers,

 

[Uncle Gizmo]

What about updating the table, then use the find duplicates query to get rid of the duplicates afterwards?

 

[ecniv]

Well...

You could, import the data to the main data tables then
- run the duplicates wizard
- create a new table from the data and use the unique value/records/distinct to get rid of duplicates.

You could import the data to an import table (delete the records held in it already if there are any)
- run an insert query linked to the main table inserting into the main table (not sure about this)
- add a boolean field to the imported table default to false. Then run an update query linked to the main table, setting boolean flag to true if it exists. Then run an insert query on all those are false (ie not in the main table).


Vince

 

[DDONNI]

cheers guys i'll try these ideas out and hopefully they'll work. Thanks again.