Community
Showing results for 
Search instead for 
Do you mean 
Reply

Importing Excel Data without Unique Identifer in ACT 6

New Member
Posts: 2
Country: United_Kingdom

Importing Excel Data without Unique Identifer in ACT 6

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

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Importing Excel Data without Unique Identifer in ACT 6

New Member
Posts: 2
Country: United_Kingdom

Re: Importing Excel Data without Unique Identifer in ACT 6

Hi,

 

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

 

Cheers

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Importing Excel Data without Unique Identifer in ACT 6