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

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?

Input

Error Message

Accepted answers

Qiu

@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-formatting-issues-with-Excel/ta-p/397305

All comments

Qiu

@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-formatting-issues-with-Excel/ta-p/397305

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703