hi,
I would like to delete duplicate rows in MS ACCESS.
Note: There are no PKEY in Database
also the DB allows duplicate records.
Please help
Regards,
DINIL
dinilkarun
8
Posting Whiz in Training
Recommended Answers
Jump to PostYou can use VBA to remove duplicates or export it to excel and click data->remove duplicates, then reimport.
All 2 Replies
buddylee17
216
Practically a Master Poster
You can use VBA to remove duplicates or export it to excel and click data->remove duplicates, then reimport.
mrsjpvan2
0
Newbie Poster
You can also create a new Table that does not allow duplicates on a field. Set the value for Indexed Property: Yes (No Duplicates). Then, paste the data from the original table. It will not copy over the duplicates.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.