Friday Did You Know? Excel to ACT OLEDB failure

By Patricia Egen • November 14th, 2014

Another Fix tipOne of the cool things you can do with ACT! is pull in data into Excel for nice pivot charts and tables.  However, every once in a while Excel and ACT get a “divorce.”  By that I mean they stop talking to each other and you get an error when you attempt to connect to a table in ACT.  Here’s our tip to fix this.

I just ran into this on my own ACT database and stumbled on a known fix that is actually quite simple.  You remove your ACT password.  Yep.  That simple.  Then try the import of the data again and presto it works.  You can then go back and set your password again, and the Excel will continue reporting.

It appears this simple fix resets the connectivity to ACT.  Thought you would find this tip helpful.


Leave a Comment

« | Home | »

  • Been sent a support request?

    Click here to enter your ticket number: Ticket

  • Our Business

    Our Mission
    Bridging the gap between technology and business processes. Provide quality business consulting, with an emphasis on technology, maintain superior client relationships and enjoy the trust and respect of our clients

  • Us in a nutshell

    CRM applications
    Data Conversion
    Custom Programming
    SQL Experts
    Lotus Notes
    Stonefield Query
    MS Office Programming
    Business analysis
    Process Workflow
    Social Media and SEO
    Linux, Mainframe
    Been there, done that

  • Facebook Like Us!