Reply
New Member
kendra@dbprosconsulting.com
Posts: 4
Country: United States
Message 1 of 12 (5,928 Views)

Access ACT! 2009 data in SQL or MS Access

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.

 

Kendra

Please use plain text.
Copper Elite Contributor
mrwright
Posts: 108
Country: United States
Message 2 of 12 (5,922 Views)

Re: Access ACT! 2009 data in SQL or MS Access

Kendra,

 

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.

 

MrWright

Please use plain text.
New Member
kendra@dbprosconsulting.com
Posts: 4
Country: United States
Message 3 of 12 (5,923 Views)

Re: Access ACT! 2009 data in SQL or MS Access

MrWright - I downloaded the SDK documents, but I'm still not seeing what I need.  Maybe it's because I'm not a developer...I have SQL Server 2005 with the Management Studio installed on the same machine as ACT! 2009...how can I get SQL to read the ACT database I'm using to be able to query off of the ACT tables within SQL?  Is this possible?
Please use plain text.
Nickel Elite Contributor
rbrust
Posts: 508
Country: USA
Message 4 of 12 (5,918 Views)

Re: Access ACT! 2009 data in SQL or MS Access

ACT Reader is what you're looking for (or SQL sa logon information). Search the ACT.com site for ACT Reader...
Richard Brust
ACT! Certified Consultant
richard@rbrDataSolutions.com
Please use plain text.
New Member
jimbrownell55@msn.com
Posts: 11
Country: United States
Message 5 of 12 (5,682 Views)

Re: Access ACT! 2009 data in SQL or MS Access

 

Does ACTReader provide the ODBC Driver for accessing ACT?  Is there a manual to go with the reader?

Please use plain text.
Moderator
dlunceford
Posts: 4,366
Country: USA
Message 6 of 12 (5,657 Views)

Re: Access ACT! 2009 data in SQL or MS Access

Yes, the ACTReader will allow you to create an ODBC connection.

 

How To Create An ODBC Connection For Use With The ACTReader Utility 

 

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.

 

What is the ACT! Reader Utility

ACT! Reader Utility Database Report Documentation

 

For details regarding the ACTReader, please call ACT! Corporate Sales at 866-903-0006. 

 

Please use plain text.
New Member
lobrien
Posts: 1
Country: United States
Message 7 of 12 (3,326 Views)

Re: Access ACT! 2009 data in SQL or MS Access

Is it a possibility to have some one make it possible to read and write data between

Access and Act 2009 premium for real estate?

Please use plain text.
Copper Contributor
Oldlaxdude
Posts: 105
Country: Canada
Message 8 of 12 (2,386 Views)

Re: Access ACT! 2009 data in SQL or MS Access

It appears that reader is only available for Act Premium,any other ways for a non techie to access data in Access/Excel

 

Thanks

Oldlaxdude

Tom David Moxam
Please use plain text.
Platinum Super Contributor
gmartin
Posts: 5,276
Country: USA
Message 9 of 12 (2,378 Views)

Re: Access ACT! 2009 data in SQL or MS Access

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

Greg Martin
Sage
Please use plain text.
Copper Contributor
Oldlaxdude
Posts: 105
Country: Canada
Message 10 of 12 (2,374 Views)

Re: Access ACT! 2009 data in SQL or MS Access

[ Edited ]

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


Thanks

Tom David Moxam
Please use plain text.