Solved

ACT and MS Access integration

Posted on 2009-04-07
6
428 Views
Last Modified: 2012-05-06
Hi Guys

I need to integrate my contacts in ACt with a DataBAse in MS Access, what i am doing now is exporting from act to excel and them importing to Access

Is there any other way to link them directly, i need to keep access up to date with any change that i do in ACT(contacts)

best regards
0
Comment
Question by:titorober23
  • 4
6 Comments
 
LVL 46

Expert Comment

by:tbsgadi
Comment Utility
0
 
LVL 30

Expert Comment

by:Mike Lazarus
Comment Utility
You only want the data to go from ACT! to Access?

Then, either OLEDB as suggested, or ODBC using the ActReader as per:
http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=22989
0
 
LVL 30

Expert Comment

by:Mike Lazarus
Comment Utility
itExport is another way to export directly to Access - http://www.glcomputing.com.au/main/64/1
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:titorober23
Comment Utility
do i need ACTreader to do all these
0
 
LVL 30

Accepted Solution

by:
Mike Lazarus earned 250 total points
Comment Utility
No.

OLEDB - Provides specific views of most of the data
ODBC - Uses ActReader to provide direct SQL access to all internal tables
itExport - exports all data from ACT! to other formats
0
 
LVL 30

Expert Comment

by:Mike Lazarus
Comment Utility
BTW: This is an article I wrote since this question:
http://blog.glcomputing.com.au/2009/04/getting-table-structure-and-links-from.html
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now