Unable to select table of excel data source due to Windows update

Progress® Telerik® Test Studio® Feedback Portal

Create an account Log In

Back to Feed

Request a Feature Report a Bug

Won't Fix

Last Updated: 17 Oct 2018 18:05 by Herb

ADMIN

Elena

Created on: 16 Oct 2017 12:20

Type: Feature Request

Unable to select table of excel data source due to Windows update

Multiple customers reported that after applying a Windows update KB4041676 on a windows 10 system all excel files bound as data source in a Test Studio project stopped working as expected - the file stayed bound but no tables appear to select any of these. 

It would be good to investigate what that update causes.

9 comments

Herb

Posted on: 17 Oct 2018 18:05

Try: https://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

Dhruv

Posted on: 09 Nov 2017 13:58

Hi Elena,
Can you please let me know the official Microsoft Security Update that fixes the previously introduced issues with Excel files? Currently, I have installed Windows Server 2008 R2 Standard Service Pack 1 64 bit.

Sai

Posted on: 08 Nov 2017 21:10

I am using windows 7 64-bit.
I am facing issue with data-binding with .xls, some one help me which windows update do I need to uninstall.

ADMIN

Elena

Posted on: 03 Nov 2017 12:30

Hi everyone! 
There is an official Microsoft Security Update which fixes the previously introduced issues with Excel files. Please find further details here: 
https://support.microsoft.com/en-us/help/4052232/windows-10-update-kb4052232

ADMIN

Andy Wieland

Posted on: 30 Oct 2017 17:10

I believe this relates: https://feedback.telerik.com/Project/161/Feedback/Details/200386-excel-datasource-doesnt-work-against-xlsx

Rick

Posted on: 25 Oct 2017 15:08

For windows 7 
I found that the Security Update for Windows (KB4041681) was the issue.
After removing, it worked correctly.

Ivan

Posted on: 19 Oct 2017 02:36

Hello Ivaylo,
I don't have installed Excel. How can I change the DB connection string? Where?

ADMIN

Ivaylo

Posted on: 18 Oct 2017 07:39

The problem is related to Microsoft update and we from Test Studio do not have control, please check for more details below and the workaround provided:

Installing this update may cause applications based on the Microsoft JET Database Engine (Microsoft Access 2007 and older or non-Microsoft applications) to fail when creating or opening Microsoft Excel .xls files. The error message is, “Unexpected error from external database driver (1). (Microsoft JET Database Engine)".

Workaround:
Download and install the Microsoft Access Database Engine 2010 Redistributable (https://www.microsoft.com/en-us/download/details.aspx?id=13255&751be11f-ede8-5a0c-058c-2ee190a24fa6=True), 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.



https://support.microsoft.com/en-us/help/4041676/windows-10-update-kb4041676

Lori

Posted on: 17 Oct 2017 13:45

I am experiencing this same issue.  I am using Windows 7, however, so it is not limited to just Windows 10 users.