Solved

ACT and MS Access integration

Posted on 2009-04-07
6
432 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
ID: 24087398
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 24088202
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
ID: 24094499
itExport is another way to export directly to Access - http://www.glcomputing.com.au/main/64/1
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:titorober23
ID: 24115569
do i need ACTreader to do all these
0
 
LVL 30

Accepted Solution

by:
Mike Lazarus earned 250 total points
ID: 24116888
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
ID: 24428362
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

785 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