Windows Security Updates are Blocking Excel

[JohnMaty]

Security Updates KB4524135 and KB4524157 are blocking exporting in Alteryx to excel.  Is there a hot fix?

Error: Output Data (8): The 2017-10-10 Windows security patch prevents the Jet driver from reading .xls files; install the 2010 32-bit Access driver

[gauravsukhadia123]

Hi there, sorry but where is the link 

[JoeS]

Hi @gauravsukhadia123 

The link is in the link below: 

https://community.alteryx.com/t5/Engine-Works/Access-Driver-Install-for-xls-File-Acess/ba-p/90145

Many thanks

Joe

[aasmith8116]

If you have tried the steps above and are still unable to use .xls files there are two other options

1. Open the file as .txt and see if it appears as a tab delimited flat file, if it does, then change the "File Format" of the input tool to say "Comma separated Value (*.csv)

You will then be able to read the file in as a tab delimited csv

2. If you open the file in text and it appears to be html format: example:

Then you will need to convert the file to a .xlsx file which can be done in command line with something like this

"C:\Program Files\Microsoft Office\root\Office16\excelcnv.exe" -oice "c:\temp\TestCodes.xls" "c:\temp\Output.xlsx"

• C:\Program Files\Microsoft Office\root\Office16\excelcnv.exe is a windows file that will convert xls to xlsx for you (You might check that directory on your local machine or somewhere within the same vacinity of the mentioned path in case it isn't labeled in a folder called Office16 in later releases of office.
• the second file path listed in the context above is the input location and filename
• the third path in the statement above is the output location and filename