Hi all,
I am aware that it is possible to input Excel Binary into Alteryx, but one must follow these steps:
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/How-to-Enable-Microsoft-Excel-Binary-Excel-Legacy-Access-accdb/ta-p/513178
Microsoft Access Database Engine 2010 Redistributable -> This is required.
Are there any other ways to do so? Especially since some companies may require explanations on why the Microsoft Access Database Engine 2010 Redistributable is required.
Or is that the only way?
Thanks,
Cal
That is the main way, and the only way I am aware of!
Yeah, just downloaded it after getting approval and Alteryx reads all legacy files just fine.
For anyone searching, downloading this: https://www.microsoft.com/en-us/download/details.aspx?id=13255
is the only way.
Hi, @caltang
If you will, you can use MADE or Python to input binary format of .xlsb file.
Hi @flying008
Thanks! Do you have a guide?
The input .xlsb method of python can use macro in gallery. please find it out as your need.
https://community.alteryx.com/t5/Community-Gallery/XLSB-Reader-and-SheetNameReader-macro/ta-p/951949
https://community.alteryx.com/t5/Community-Gallery/Convert-xlsb-into-xlsx-and-parse-the-input/ta-p/1009750
Thanks! Though I think it is much easier to download the Microsoft Redistributable package, and is easier in terms of UI/UX for the end users.
Even you already installed MADE, then you can input one sheet data of xlsb file indirectly, but you can't import only the list of sheet names.
