I have been able to open the Act DBF file with contact information by using an ODBC connector and extracting the information into MS SQL.
However, I can not find the Appointments and Notes files that correspond to the contacts. The Act Software that is being used has been customized and I'm afraid that may be the problem.
Opening the contacts was a nightmare because there were 250 extra columns added so I had to break it up because no software would open the entire table with that many columns (not sure how they created it, it must be a DBase feature that MS didn't allow for, but I digress.)
Here are the file extensions listed in the Act Folder:
I'm thinking the adb file is the appointments file, but if it is, how do I connect to it. I've tried changing the extension and using ODBC connector for DBase, and that didn't work. I have extracted what I need from the .dbf file.
Because this database has been customized, the standard export software on the market does not seem to work.
Thanks for any information on how to extract this information.