Importing Excel Data without Unique Identifer in ACT 6

[Steviec334567]

Hi,

I work for a company that has a ACT 6. We have a database that contains some pretty old data.

We would like to update this data with data from a new database held by our sister company.

There are likely to be duplicates, dead records, amended address' etc.

I imported records a couple of years ago that i managed to add my OWN unique identifer to so i could update easily in the future. This is done by setting duplicate setting to match on the field i choose as unique identifer.

However there still are records without this visual unique identifer that i need to update. If i change my duplicate parameters to search on postcode/company name/phone number it still creates duplicates instead of updating.

Is there software i can purchase to help with this problem?

I seen someone on here had an add on called HEROTECHNICAL but i couldnt find the plug in folder in ACT 6 (possibly doesnt have one)

Any help would be greatly appreciated or advise i have 23000 to look at.

Thanks

[GLComputing]

You need to look at Oak!merge!
http://www.glcomputing.com.au/main/19/2

[Steviec334567]

Hi,

Thanks for this do you know what sort of costs are involved?

Cheers

[GLComputing]

About AU$345