Free Trial

Alteryx Designer Desktop Discussions

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

Imput excel .xlsb files

Silva
5 - Atom

I work with several excel .xlsb files but I can't add those to Alteryx Designer Version 2020.4.5.12471

 

The Excel Binary option shows under Files connections like below.

 

Silva_0-1610365795114.png

 

but it doesn't show under the dropdown options

Silva_1-1610366014971.png

 

Any solution to overcame this?

 

Thanks

3 REPLIES 3
Emil_Kos
17 - Castor
17 - Castor

Hi @Silva,

 

Did you try dropping the file into the canvas? 

 

It should properly identify the format for you. 

 

If it will not work please try this access drive:

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/working-with-xlsb-files-in-Alteryx/m-p...

joshuaburkhow
ACE Emeritus
ACE Emeritus

Hey @Silva 

 

Can you try just typing it into the box here: 

joshuaburkhow_0-1610366947902.png

 

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
Silva
5 - Atom

Dropping the files doesn't work.

 

But I've installed the Access driver and now works!

 

Many thanks

Labels
Top Solution Authors