Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
bac bac is offline
external usenet poster
 
Posts: 76
Default VBA Code to access the ACT! 2005 data bases and tables

We are upgrading to the ACT!2005 software for contact management and need to
be able to read the data tables directly. act.com has a KB article on using
the OLEDB Provider for ACT reporting, and several discussion group threads
discuss the efforts of users to access the tables.

There ia an ACT! utility and an SDK for "exporting" the data from ACT!, but
it lacks the flexibility I'm looking for.

Has anyone here used the OLEDB Provider to Access ACT!

What is the connect string?
What is the code to create the database/recordset objects =(or is it the
same as other datasets)?

Any help would be appreciated..

TIA

BAC
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
External data link to Access - no linked tables? Grant I Excel Discussion (Misc queries) 3 January 30th 09 06:27 AM
Removing Data Tables formed from importing data from Access Andrea Jones Excel Discussion (Misc queries) 0 April 10th 08 12:01 PM
I want to combine 2 workbook data bases and remove duplicates phil Excel Discussion (Misc queries) 1 September 16th 06 03:20 AM
compare 2 data bases that change each month. Only account number styx44 New Users to Excel 1 May 1st 05 07:03 PM
Data tracking import to Access with more than 25 tables John Hipskind Excel Programming 0 January 14th 04 02:51 AM


All times are GMT +1. The time now is 06:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"