02-19-2009 09:57 AM
Is there a way to access the ACT tables and data in SQL or Access through an ODBC connection? If so, does this require purchasing a 3rd party application?
Purpose: I am trying to export Notes from an ACT 2009 database and can't seem to find the best way to do this. I'm hoping not to have to purchase an add-on product, but if it comes to that, I may have no choice.
02-19-2009 11:36 AM
It sounds like you understand data access so you may find the Act! 2009 SDK helpful to you. You can find a link to it Act! 2009 (11.0) SDK. This should answer some questions.
02-19-2009 12:04 PM
02-19-2009 12:27 PM
03-24-2009 08:24 AM
Yes, the ACTReader will allow you to create an ODBC connection.
ACT! Reader Utility
The ACT! Reader Utility is designed to meet the preponderating and data-extraction needs of some ACT! corporate customers. The ACT Reader account provides read-only access to most data tables within ACT!. Once connection is made to the ACT! database, third-party tools such as Crystal Reports® can be used to query these tables for advanced reporting and data extraction.
The ACT! Reader Utility allows the user to establish and set a user-defined password to log in to the ACT! Reader account. The ACT! Reader Utility also provides the ability to define, change, and reset the password.
For details regarding the ACTReader, please call ACT! Corporate Sales at 866-903-0006.
08-05-2010 09:08 AM
You can access the data through the OLE/DB function using Excel. Here is an article the has the steps for creating the connection through Excel: KB Article 25186
08-05-2010 09:54 AM - edited 08-05-2010 11:17 AM
I tried all that,
I don't have option for 2.0 and I get errror message:
Provider no longer available. Ensure provider is installed properly.
So how do I re-install?
I did the database rebuild OLEDB repair as per KB, didn't help