asked on

Unexpected error from external database driver (1).

We have Access 2003 and Excel 2007. Forever we have been able to right click a table in Access and Export to Excel 2003-2007. Today, we get that error above. Table size or content doesn't matter. Why would it all of a sudden not work?

John Tsioumpris

Possibly an Office update and/or a 3rd party software install that affected the procedure...unless you have hit the custom sheet name..or a column limit...
Have you tried to export the table via code to see if you get more info...

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, YourTableName, outputFileName, True

Open in new window

or a bit more complex but with better control try this

pkromer

ASKER

This is starting to sound like an MS update, researching...

ASKER CERTIFIED SOLUTION

Edgar Aquino

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pkromer

ASKER

THANK YOU.

Brian Chaikin

This is a great solution and i was able to uninstall the update on Win 7 machines. MY next challenge is Win 10. I cannot see the windows security updates to uninstall it. I only see the office updates.

Anyone know of a work around for this?

Mark Bell

Thank you Edgar! I was suddenly having problems with my Crystal Reports 2011 program being able to connect to my Excel datasource. I uninstalled KB4041681 and voila - it once again works! Hopefully Microsoft will address this in a future release.

Edgar Aquino

Brian,

I do not have a win 10 computer where I am using any Excel or Access, I would give KB4041676 a try, remove and see if it will fix, if not just install again.

Brian Chaikin

That did it. Thanks so much for your help.

Saravanan V

Download and install the Microsoft Access Database Engine 2010 Redistributable, and then modify the DB connection strings in Microsoft Excel to use ACE as a provider. Example: Change Provider=Microsoft.Jet.OLEDB.4.0 to Provider=Microsoft.ACE.OLEDB.12.0.

Microsoft is working on a resolution and will provide an update in an upcoming release.