MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 257|Reply: 4

Delete duplicates based on certain columns

[Copy link]

11

Topics

27

Posts

81

Integral

Member

Rank: 2

Integral
81
Post on 1-6-2017 10:20:37 | All posts |Read mode
Hi there,
I am looking for a way to find a remove duplicates from a table in Access. Right now we import a table, run some queries, export to Excel in order to remove duplicates, then re-import the table to Access to run more queries.
Is there any way around this at all? It is quite annoying and often times it makes our databases exceed the 2M KB limit.
Thanks!




Reply

Props Report

11

Topics

27

Posts

81

Integral

Member

Rank: 2

Integral
81
 Author| Post on 1-6-2017 10:46:09 | All posts



I should add that we only want to remove duplicates based on 7 columns (the table itself has about 50 columns).




Reply Support Opposition

Props Report

4

Topics

567

Posts

1222

Integral

King

Rank: 6Rank: 6

Integral
1222
Post on 1-6-2017 11:21:14 | All posts



You can use the method detailed in link.
https://support.microsoft.com/en-us/kb/209183
FYI - I don't know how your data is populated in Access. But, it's usually more efficient to eliminate duplicates at input stage rather than removing them after the fact.
Reply Support Opposition

Props Report

4

Topics

567

Posts

1222

Integral

King

Rank: 6Rank: 6

Integral
1222
Post on 1-6-2017 12:47:42 | All posts



You can use the method detailed in link.
https://support.microsoft.com/en-us/kb/209183
FYI - I don't know how your data is populated in Access. But, it's usually more efficient to eliminate duplicates at input stage rather than removing them after the fact.




Reply Support Opposition

Props Report

3

Topics

94

Posts

231

Integral

Conqueror

Rank: 3Rank: 3

Integral
231
Post on 1-6-2017 13:00:12 | All posts



In Access, check out deleting duplicate records.  Depending on the Version, there usually was a Wizard to help set it up. ~ I have seen other cases where people add a Check box in the Duplicate query, to allow you to choose which record to delete (in case there was other info you needed to keep).  Stay in Access, use delete duplicates .
Reply Support Opposition

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 9-24-2017 21:26 , Processed in 0.246391 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!