XLSB File Type

I am trying to read from an XLSB Excel File.

I am using Alteryx Version 2019.4.

I have the MS Access 2016 Database Engine Installed.

When I add an input, I can see "Microsoft Excel Binary XLSB" as a Supported File Type, but when I get to the Window to then select the File, there is not anoption for XLSB. If I choose All Files to see and choose the XLSB files, Alteryx does not like it.

I have seen in other posts the reference to installing the MS Access 2010 Database Engine, but I would think the 2016 should allow the same.

Any thoughts or ideas here? Thanks much.

Input

Accepted answers

All comments

echuong1

You'll need to make sure that you have the correct Access driver installed as specified in the Supported Data Sources page within Help section. Can you try downloading this and see if it works? Let me know!

bmturek

Thanks, yeah, I had the 2016 DB Engine installed, and after I also installed the 2010 Version, I was able to have XLSB as in input.

In my Configuration for XLSB Input File, I do not have the Option for "Start Data Input on Line" like I do for other Excel File Types.

Is this a limitation with XLSB files for some reason? Thanks.

khushb373

Hello Team,

I am also facing similar issue, please advise on how to get this resolved

Felipe_Ribeir0

Hi @khushb373

You could try to convert the .xlsb file into a .xlsx file with this macro. Here it works fine.

Convert .xlsb into .xlsx and parse the input - Alteryx Community

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703