Start Free Trial

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