XLSB input Error: Microsoft Access Database Engine: External table is not in the expected
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Labels:
- Error Message
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Try the possible solution below
1. Remove the password if exist.
2. Open the XLSB file and manually add some dummy data, then save
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.