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
Solved! Go to Solution.
Apparently you need the 2010 Access Driver to read .xlsb files.
https://www.microsoft.com/en-us/download/details.aspx?id=13255
Cheers,
As @Thableaus suggested you will need an access driver. All data source pre-requisites are listed on our help pages for future reference
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?
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,
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.
It isn't workng even after that. I am getting system resource exceeded.