+ Reply to Thread
Results 1 to 4 of 4

Delete duplicates based on certain columns

  1. #1
    Registered User
    Join Date
    11-22-2016
    Location
    New York, NY
    MS-Off Ver
    2016
    Posts
    37

    Delete duplicates based on certain columns

    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!

  2. #2
    Registered User
    Join Date
    11-22-2016
    Location
    New York, NY
    MS-Off Ver
    2016
    Posts
    37

    Re: Delete duplicates based on certain columns

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

  3. #3
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Delete duplicates based on certain columns

    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.

  4. #4
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: Delete duplicates based on certain columns

    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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Compare columns and delete duplicates
    By ephrahim in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-24-2013, 03:38 PM
  2. Compare two columns delete duplicates
    By camo090 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-16-2013, 03:59 PM
  3. Delete duplicates value combinations from two columns
    By Julia2937 in forum Excel General
    Replies: 2
    Last Post: 03-29-2013, 07:03 PM
  4. [SOLVED] Remove Duplicates in Columns but also delete Row
    By iteriwarren in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 08-21-2012, 09:21 AM
  5. Delete duplicates in 2 columns
    By greek in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-08-2011, 05:35 AM
  6. Replies: 17
    Last Post: 07-05-2011, 05:37 PM
  7. delete duplicates in 2 columns
    By k2extrem5 in forum Excel General
    Replies: 0
    Last Post: 05-10-2005, 07:05 PM
  8. Rows to columns and delete duplicates
    By msick in forum Excel General
    Replies: 0
    Last Post: 04-19-2005, 09:53 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1