Transfer duplicates into new table

[dntel123]

Hi Guys,

Bit rusty on Access haven't done it since uni, and not in 2010.

I have a file that is too big to open in Excel so I need to take all the people with duplicate identifiers and place them in a new table.

Can someone give me some guidance of how to take duplicates out and put into a new table that I can then export out?

Thanks a lot!
Liam

 

[Beetle]

I would suggest just creating a query that returns the duplicates, and output the query. There is (at least in older versions of Access - I don't have A2010) a Find Duplicates query wizard that you can use if you need to.