Alteryx does not give the option to import the excel file with extension .xlsb.
Somebody please help me on this.
Any support will be highly appericated.
Thanks,
Kamran
Hi @Kamran1991
Please find the below link whether a similar issue has been resolved.
Hope this link will help to resolve your issue too.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Excel-xlsb-Files-in-2018-1/td-p/159152
Many thanks
Shanker V
Hi @Kamran1991
One way of doing this is by using one of these macros:
https://community.alteryx.com/t5/Community-Gallery/Read-All-Excel-Files/ta-p/897750
https://community.alteryx.com/t5/Community-Gallery/XLSB-Reader-and-SheetNameReader-macro/ta-p/951949
Hi @Kamran1991 - Alteryx requires Microsoft Access Database Engine 2010 driver to be installed to natively read xlsb format: https://www.microsoft.com/en-us/download/details.aspx?id=13255
This solution was also provided in one of the links above.
@ArtApa - I know this is a late response on this thread, but was wondering if this is still the optimal solution for Windows 11 machines. According to the Microsoft site this driver is only supported up to Windows 10. Or does that not matter?
Thank you