I have a telemarketing database with the following fields (Phone, Name, Address, Neighborhood, State and Zip), but in this database there are thousands of duplicate contacts and I need to delete these quickly and efficiently contacts before importing it to my system, I've already tried using excel that deletes the duplicates, however, or it does not delete all or it deletes and disorganises the data.
Can anyone help me do this either in Excel or in Access ??