working on xlsb in alteryx on 2019.1 version

[Mahabirpanigrahi]

I have 2019.1 version, am trying to connect xlsb files but its not allowing me to. I dont see any such source there.

While i know, its been part from 2018 and up version. Any one can help ?

I found few other post  here on community. I found a macro to run it but i want to simple input. Is that possible ?

https://help.alteryx.com/2019.1/DataSources/SupportedDataSources.htm  

https://community.alteryx.com/t5/Engine-Works-Blog/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-AL...

[Thableaus · Accepted solution]

Hi @Mahabirpanigrahi 

Apparently you need the 2010 Access Driver to read .xlsb files.

https://www.microsoft.com/en-us/download/details.aspx?id=13255

Cheers,

[MichalM · Accepted solution]

@Mahabirpanigrahi 

As @Thableaus suggested you will need an access driver. All data source pre-requisites are listed on our help pages for future reference

 

[Mahabirpanigrahi]

Thank you @michalM. I have MS Access 2016 on my system, not sure how its different from 2010.

One more thing, While running from Alteryx server, will it read the xlsb source?

[Thableaus]

@Mahabirpanigrahi 

You need the Access Driver, not Microsoft Access software.

This link directs you to the driver: https://www.microsoft.com/en-us/download/details.aspx?id=13255

You need to install the driver on your Server as well.

Cheers,

[MichalM]

@Mahabirpanigrahi 

Whenever you think about the server, think of it as if it was just another computer running the Designer. Whatever you need to do to connect to a DB or open an xlsb file, the same will need to be replicated on each worker of your Alteryx Server.

[Sri9]

It isn't workng even after that. I am getting system resource exceeded.