Join the Inspire AMA with Joshua Burkhow, March 31-April 4. Ask, share, and connect with the Alteryx community!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

how to read .XLSB file in designer

curator_at_work
8 - Asteroid

how to read .XLSB file in designer, 

7 REPLIES 7
Gumsmenezes
10 - Fireball

Hi there, just like you would normally do with a xlsx file. I personally like to drag from the folder directly to the Canva.

curator_at_work
8 - Asteroid

No , it's not working, throwing error

 

 

Gumsmenezes
10 - Fireball

Make sure you change #2 to .xlsb

curator_at_work
8 - Asteroid

there .xlsb is not an option

Gumsmenezes
10 - Fireball

It could be a version issue. What version are you using?

You can check this post: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Excel-xlsb-Files-in-2018-1/m-p...

I attached what it looks like in version 2023.2, for you reference.

curator_at_work
8 - Asteroid

I am using 2021.4

DavidSkaife
14 - Magnetar

Hi @curator_at_work 

 

Try this link to download the Access Drivers you need - https://www.microsoft.com/en-us/download/details.aspx?id=39358

 

It's the recommended version based on this KB article - https://knowledge.alteryx.com/index/s/article/How-to-Enable-Microsoft-Excel-Binary-Excel-Legacy-Acce...

Labels
Top Solution Authors