Acces SQL duplicates

Lesceline Gibson

Well-known Member
Joined
Apr 6, 2012
Messages
753
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
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,327
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.
 

Lesceline Gibson

Well-known Member
Joined
Apr 6, 2012
Messages
753
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

Active Member
Joined
Feb 5, 2018
Messages
302
Office Version
365, 2016
Platform
Windows
After you do the query wizard you should be able to save the resulting query to run later as often as you want.
 

Lesceline Gibson

Well-known Member
Joined
Apr 6, 2012
Messages
753
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

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,601
Office Version
2013
Platform
Windows
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.
 

Forum statistics

Threads
1,089,218
Messages
5,406,922
Members
403,112
Latest member
rminor

This Week's Hot Topics

Top