Member Avatar for dinilkarun

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

  • 3 Contributors
  • 2 Replies
  • 85 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by mrsjpvan2
Member Avatar for buddylee17

You can use VBA to remove duplicates or export it to excel and click data->remove duplicates, then reimport.

Member Avatar for mrsjpvan2

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.