Client Service Center

Error When Importing and Exporting Excel Timesheets and Files
Published on by Rhonda Siex in Blog Posts, CS3 Technology

 

In the last week, we have seen more and more clients get an error when trying to import Excel timesheets or attempting to create Excel export files to other programs.

This error is showing itself in both Sage products (accounting and HRMS).

The error (pictured below): “Unexpected error from external database driver” was caused by recent Windows Security updates.

Two possible resolutions have been found:
1.
When speaking with Sage, the solution they are able to provide us at this time is to roll back the recent security updates on the affected workstations. There has not been an update from Sage regarding this item. Clients who have done this have seen the error resolve.

The Sage Knowledgebase link for this error referenced in this KB Link.

2.
However, Microsoft has noted the issue on their website. Microsoft has provided a workaround for the error by downloading and installing the Microsoft Access Database Engine 2010 Redistributable, and then modify DB connection strings in Microsoft Excel to use ACE as a provider. (Example: Change Provider=Mocrosoft.Jet.OLEDB.4.0 to Provider=Mocrosoft.ACE.OLEDB.12.0)


Error Message

(877) 496-1600

Logo for CS3 Technology.

Pages

Software

Resources

Contact

This website is owned by CS3 Technology. CS3 Technology is independent from Sage and is not authorized to make any statement, representation, or warranties or grant any license or permission on behalf of Sage regarding any product, service, or website content. Certain materials made available on or through this website are owned by Sage and cannot be used without the prior written permission of Sage.