Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT 2000 Export With Unique Id

New Member
Posts: 2
Country: United Kingdom

ACT 2000 Export With Unique Id

I am trying to export/import contact data from ACT 2000 in to a SQL database. Unfortunately the export/import will require a primary key.

 

Does ACT 2000 allow data to be exported with a primary key and if so how?

Copper Contributor
Posts: 16
Country: United Kingdom

Re: ACT 2000 Export With Unique Id

Hi  

 

ACT 2000 has a system field that is a unique id field. The best way to get all the contact data (not notes, history, etc.) is to open the ACT DBF file in Excel. If you want all the ACT data out in a relation structure try a product called ACT to Access. Hope this helps 

 

Chip  

 

Independent ACT Support UK

 

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: ACT 2000 Export With Unique Id

New Member
Posts: 2
Country: United Kingdom

Re: ACT 2000 Export With Unique Id

Thank you both for your help.

 

Without a unique key in ACT I would have been stumped, both of these apps look like they are exactly what I was looking for.

 

Thanks again.