Acces SQL duplicates

[mahmed1]

Hi All
i have a table where i have accidently imported in data multiple times.

I am trying to delete out all the duplicate values and cant find some SQL that to do this

can you please advise

thank you

 

[bobsan42]

use the query wizard in access: Create / Query Wizard >Find duplicates Query Wizard
Of course this will require to have in your table a field to match them as duplicates.

 

[mahmed1]

Is there any SQL script i can write to achieve the same results?

i want to be able to run a saved script just encase there are more dups in the future

 

[JonXL]

After you do the query wizard you should be able to save the resulting query to run later as often as you want.

 

[mahmed1]

Oh ok - ive never used this before so thought there was a generic script i could have used

il try and give that a go

 

[xenou]

It depends on how your table is structured - no precisely generic scripts for this, many ways to do it anyway, plus in general everything needs to be customized to fit your table structure and columns so in fact the query wizard as as close as you'll get to plug and play.

 

[mahmed1]

Thank you