cancel
Showing results for 
Search instead for 
Did you mean: 

Engine Works Blog

Under the hood of Alteryx: tips, tricks and how-to's.
FRIDAY Deadline | Submit your Alteryx Use Case by August 17th to qualify for this round of Analytics Excellence Awards presented at Inspire Europe 2018! Learn more.
Alteryx
Alteryx

Driver Updates

With the release of 11.7, Alteryx will be able to access .xls files again if you use the Access 32-bit 2010 driver.

 

What happened?!?!?!

The 2017-10-10 security patch from Microsoft unexpectedly impacted the Jet driver and 64-bit versions of the Access drivers. These drivers now have issues reading in certain data types. The following Windows versions were impacted:

 

Windows 7 8.1 10 Originial 10 1511 10 1607 10 1703 (Creators)
Windows Server 2008 R2 2012 2012 R2 2016    

 

Basically, the Jet driver can't tell the difference between some data types, and it is trying to mismatch them.

RoundHoleSquarePeg.pngThose match, right? Totally the same thing

 

 

 

 

 

 

 

 

 

 

 

 

 

 

But I can still access .xls...?

That's great! That means you are either on a version that wasn't impacted or you didn't install the patch. If that's the case, just don't install that patch until this gets resolved!

 

Well, I'm on one of those AND I have the patch. What do I have to do?

Head over to this page and install the 32-bit 2010 Access driver. Be sure to install the 32-bit version, because it matches the behavior of the pre-patch Jet driver perfectly. In fact, it matches so perfectly, we don't even check for the 64-bit version!

 

Once 11.7 is release, install the new Designer and start accessing those .xls files again!

 

spreadsheet.jpgOh spreadsheets, how we've missed you! 

Tanya Stere
Technical Writer

Tanya Stere is an Alteryx Technical Writer, responsible for translating Developer-ese into English. Tanya primarily tries to improve processes and create consistency in all the content she works with, be it data source support or predictive tool use.

Tanya Stere is an Alteryx Technical Writer, responsible for translating Developer-ese into English. Tanya primarily tries to improve processes and create consistency in all the content she works with, be it data source support or predictive tool use.

Comments
Meteor

I had the problem that you mentioned - your fix worked like a charm. Thanks so much for sharing this.

Bolide

I am using windows 10 machine and Alteryx designer 11.7. I am getting following error while trying to read .xls files even after installing 32 bit access driver. Can someone help ?

 

"Get Table List Error: The 2017-10-10 Windows security patch prevents the Jet driver from reading .xls files; install the 2010 32-bit Access driver"

Alteryx
Alteryx

@ponraj Did you install the 2010 32-bit Access driver? There are different versions of the driver for different years, but they don't handle the data type recognition issue. You need the 2010 version specifically.

Bolide

@TanyaS, Thanks for your response.  I downloaded and installed 2010 32-bit access driver from following link. Still the issue persists.  

 

https://www.microsoft.com/en-us/download/details.aspx?id=13255

 

 

Alteryx
Alteryx

@ponraj Thanks for confirming. Your best course of action is to reach out to customer support. Sorry I can't help more!

Labels