08-28-2008 01:10 AM
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?
08-28-2008 08:15 AM
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
08-28-2008 09:02 PM
08-29-2008 12:32 AM
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.