ACT and MS Access integration

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
titorober23Asked:
Who is Participating?
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
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
 
tbsgadiCommented:
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
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
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
itExport is another way to export directly to Access - http://www.glcomputing.com.au/main/64/1
0
 
titorober23Author Commented:
do i need ACTreader to do all these
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.