How to output an xlsb file

[KMadamba]

Hi,

What I am trying to do is to gather one specific sheet from all files that may have these file types (xlsx, xlsm, and xlsb ) and output them in the same file type after the workflow has done its data blending. I have no problems doing this with xlsx and xlsm but..

How do I this with .xlsb files?

I am getting this error:

Error: Output Data (128): Error creating table "'Sheet1$'": Microsoft Access Database Engine: ''Sheet1$'' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.\3125 = -537199594

My configuration looks like this:

The Field name PATH looks like this:

There are no problems with this formula on xlsm and xlsx.. just the xlsb files.

Any help would be greatly appreciated.

Thanks

[jamielaird · Accepted solution]

Hi @KMadamba 

Do you have the correct Access driver installed?

See here for more details: https://help.alteryx.com/current/DataSources/SupportedDataSources.htm

[KMadamba]

Thank you for the quick response @jamielaird !

I had a 2007 version installed. Time for me to upgrade.

Cheers

[JokeFun]

Is there any other options other than installation of the 2010 access database engine since my company does not allow the installation of this?