Remove Duplicates with MS Access, create Excel-file
$30-250 USD
Completed
Posted over 13 years ago
$30-250 USD
Paid on delivery
Pls. see the files [login to view URL] and also [login to view URL] :
[login to view URL]
[login to view URL]
From there, you need to eliminate all duplicate database entries. As primary keys to identify a unique person or company you use Name, Firstname, ZIP-Location. If those 3 parameters are equal, leave only 1 Data-Set and remove the others, if any.
When finished, sort the [login to view URL] file by a)Profession, b)Sector, c)Firstname and d)ZIP-Location.
Hi,
I have loaded ~32K Records to my Local Database. Now it is a matter of running some queries on top of it to cleanse Data.
Please see more details in your PM
Regards
DI Solution