Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

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

yizhuo
7 - Meteor

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? 

 

yizhuo_0-1621903619413.png

 

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@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
7 - Meteor

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
21 - Polaris
21 - Polaris

@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...

Labels
Top Solution Authors