[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

ACT and MS Access integration

Posted on 2009-04-07
6
Medium Priority
?
450 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 new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 

Author Comment

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

Accepted Solution

by:
Mike Lazarus earned 1000 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

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

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

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Introduction to Processes
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

591 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