Results 1 to 3 of 3
  1. #1
    Join Date
    May 2009
    Posts
    41

    Unanswered: What's the proper way to export from ACT! into Access?

    Tried searching around the Access forums for this and couldn't find a solution. Has anyone ever tried exporting contact information from ACT! into Access?

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    ACT! has a propietary database. You can try seeing if there is a driver to connect to an ACT! database and install that driver (creating an ODBC type connection using that driver) and then link the tables into Access using the ODBC connection. Finding the driver might be tricky though. We didn't go with ACT! because it had no ability to connect with it in the older versions. You can check to see if Prograsive has such a driver - their's is an ODBC replacement. Otherwise anyone with moderate MSAccess skills could design an ACT! clone in-house (limited version). I'd also download the latest MDAC and hope a driver is in that (but doubtful) You'll most likely have to see if you can get it from ACT! itself. They don't like others to see behind the scenes and their structure (same with Quickbooks).

    Otherwise, with the newer versions of ACT! you can export most of the data into a csv file. I would check into the ACT! command line parameters and see if you could automate this procedure (using task schedular to execute the vb script or bat file to do this) and then either import into MSAccess or just link to the table(s).
    Last edited by pkstormy; 06-07-09 at 22:43.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    You might have more luck on an Act! specific forum. The developer's website specifically states that it can be integrated with all MS Office products.

    Like pk, if this is advance planning and you're not actually using Act! as of yet, developing an Act! clone using Access would be fairly easy, I suspect.

    This is a moot point, of course, if you're already using Act!
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •