ACT 2000 Export With Unique Id

[david_ste]

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?

[Chip]

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

[GLComputing]

You should probably try this addon - http://www.jltechnical.com/ACTExport.htm

[david_ste]

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.