XLSB input Error: Microsoft Access Database Engine: External table is not in the expected

[yizhuo]

I am trying to input a xlsb file but run into the following error message: 

Error: Input Data (1): Error opening connect string: Microsoft Access Database Engine: External table is not in the expected format.\3274 = -328602519

I have downloaded the driver at here: https://www.microsoft.com/en-us/download/details.aspx?id=10910 and previous xlsb input were ok. Not sure what's wrong this time? 

[Qiu · Accepted solution]

@yizhuo 

Try the possible solution below

1. Remove the password if exist.

2. Open the XLSB file and manually add some dummy data, then save

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-check-for-encoding-or-format...

[yizhuo]

Super helpful! I edited the "_rels" to match a working xlsb sheet and it works! 

Just curious if you happen to know under the circumstances that I have multiple sheets, any chance I can fix the files all at once? It seems like I have to manually fix the files before inputting to Alteryx. 

[Qiu]

@yizhuo 
Glad to help and thank you for the accept mark.

For the follow-up question, maybe you can try the macro made by @MarqueeCrew , Hope you will be lucky.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/quot-InvalidArgument-Value-of-0-is-not...