How do I input .xlsb files

[sonseeahray]

Looked but was unable to determine what it is I need to do to be able to us Excel .xlsb files as input. I am using version 2020.1.1. 

When I try to connect it with a file of this type I receive that it is not a recognized type:

And if I try to drag and drop I receive the blocked icon and unable to drop it.

[ggruccio · Accepted solution]

Hi @sonseeahray,

I have not seen this issue before so did some research...the choice for xlsb appears for me....

This article appears to address your issue.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Excel-xlsb-Files-in-2018-1/td-p/159152

[sonseeahray]

Hi @ggruccio, I'll take a look. Thank you!

[sonseeahray]

@ggruccio My goodness that is it. Thank you!!

[SharkeyNZ]

I am having this issue with *.xlsb files (Alteryx Designer 2022.1.1.30961).  In my company we are restricted to Microsoft Access Database Engine Redistributable 2016 (2010 has been replaced due to some vulnerability). However, I am unable to open *.xlsb files with version.  Is anyone else having this issue?

[amitios]

Thank you for the solution

[subha11]

thank you for the solution

[subha11]

okay

[subha11]

okay

[subha11]

thank you