by harshvar on March 20th, 2006

Question

Help answer this question below.

How can I delete duplicate entries from a table without losing the data?

Like
Report

Share:: Facebook; Twitter; Other

Answers. 1 helpful answer below.

by Mushen on November 18th, 2006
In access: copy the table.

Create a Find Duplicates Query (wizard).
Create a Delete Query
Create Update Query

Create a macro to run 3 queries together.
Look in Help - it will tell you step by step what to do
Comments
Add a comment...
- Like
- Report
No comments. Post one | Permalink

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

What is the next application to upgrade to after I have collected more data than MS Access can handle?
by joningram on August 19th, 2010 | 1 person likes this
Nero Wolfe or a werewolf?
by Want To Sleep With A Miner on August 15th, 2010 | 2 people like this
Are there ways of making technical information accessible? Are there ways of making simple information inaccessible?
by onc.again on October 24th, 2010 | 1 person likes this
Which SaaS integration solution is the best? Please help.
by ceenam08 on April 21st, 2010 | 1 person likes this
LATEST VERSION OF SQL SERVER
by jdyonline on September 14th, 2010 | 1 person likes this
More Database software (General) See only professionally researched Database software (General) questions

You're reading How can I delete duplicate entries from a table without losing the data?

Follow us on Facebook!

Related Ads

Professionally Researched

ANSWERBAG BUZZ

Why do toenails get thick

Macro access 2002 remove duplicate entries

About Us

About Answerbag

Sitemap

Professionally Researched Questions

Legal

Privacy Policy

Terms of Use

Disclaimer

Ad Choices
Follow Us on Facebook

Answerbag.com
Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!
Latest Tweet

What is the very worst thing you can do in an interview? http://t.co/3QoM2mLE

Follow Answerbag on Twitter!

Answerbag

Question

How can I delete duplicate entries from a table without losing the data?

Answers. 1 helpful answer below.

Comments

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

Follow us on Facebook!

Related Ads

Related Questions

I've just run Regseeker, it has highlighted ~3000 entries to delete. I deleted all the green entries safely, but there's still around 500 red entries: invalid activex/com entries, unused file extensions and "open with" entries, can I delete these safely?

Can you restore a computer with Win XP Pro Recovery Console without losing data?

Peachtree= Error 2 PAWencript acquire our container" the to company screen, "data corrupted, restore" can't get into program to restore. Have tried repair and reinstall. No help. Can I remove peachtree and reinstall without losing my data.

What silver-white metal can be extracted from table salt?

How do I remove duplicate calendar entries in Outlook?

Professionally Researched

Can you restore a computer with Win XP Pro Recovery Console without losing data?

What silver-white metal can be extracted from table salt?

How do I remove duplicate calendar entries in Outlook?

How do I remove duplicate entries in Excel?

How do I change the battery in the iPAQ 1910 without losing data?

ANSWERBAG BUZZ

Answerbag.com
Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!

Question

How can I delete duplicate entries from a table without losing the data?

Answers. 1 helpful answer below.

Comments

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

Follow us on Facebook!

Related Ads

Related Questions

Professionally Researched

ANSWERBAG BUZZ

Answerbag.com Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!

Answerbag.com
Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!