Hi All,
I work a lot with XLsb files and want to ask if anyone has come up with a way to read only XLsb files. I want to extract some data from these files to run some analysis.
Thanks
@Dynamomo
Love this macro
@LordNeilLord
Part time Tableau, Part Time Alteryx. Full Time Awesome
Hi @JulianV,
xlsb files are now supported in Alteryx 2018 so if you upgrade to that, you should be good.
If you don't want to upgrade, another option is the Excel Holiday Macro that was built by an Cameron Steele at Alteryx. IT's a really awesome macro that makes bringing in Excel files a lot easier. check out the blog post - https://community.alteryx.com/t5/Engine-Works-Blog/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-ALL-Excel-Macro/ba-p/9988
if you scroll to the bottom of it, you will see a link to it in the Gallery.
Hi Dynamomo,
I have the latest version of Alteryx (11.8.4) but still does not support xlsb files. The Excel Macro Holiday works for me so thank you for your help
Hi @Dynamomo,I am connecting to some .xlsb files but I can not see the option in the dropdown of the input tool. I am using Alteryx 2019.1 version which I download recently, I have 2018.3 on another laptop and I can find that option easily, any idea why this might be happening? Thanks,
I am using 2020.4 and have MS Access 2016 installed, still cannot handle xlsb file. I am not allowed to install MS Access 2010 driver in my office. Any solution ?
