is there a limit to number of columns for xlsb file input?

[Kate]

the file I want to use has ~460 columns in but only 255 are currently being input.  Is there a way of inputting all 460 for an xlsb file?

THanks

[JakeS · Accepted solution]

Hi @Kate

Looking at the Alteryx Excel help documentation under the "lengths and limits" section:

While this documentation is for xlsx files, the binary files are read using the Legacy Driver for Microsoft Excel, putting a limit at 255 columns. You can get around this by converting the file to xlsx if possible. 

Jake

[cking6178]

Is there another workaround for this? I had to install the 2010 Access driver to have the ability to read in the .xlsb file in the first place. The binary file is 58MB, converting that to an .xlsx file will put it > 150MB, which will crush the resources on my machine.