Issue with importing .xlsb file

[sumitgupta591]

Hi, I am unable to import a particular file with ".xlsb" extension. However, if I import another file with same extension it gets imported without any error. Below is the error screenshot I am getting: 

Thanks in advance !

[MichalM]

@sumitgupta591 

The error comes from the MS Access Database Engine which is the driver we use to read in Excel binary files and could suggest something is corrupted within the file. Sometimes that error occurs when the file is created as an export from a third-party program like an accounting system. These files can contain minor inconsistencies in their XML schema resulting in the error.

Could you open the file in Excel, save it as xlsx and try opening it in again?

[sumitgupta591]

Is there any way I can deal with .xlsb file since I do not want to use .xlsx version file (due to large size issue)?

[Aguisande · Accepted solution]

Downloading and installing "Microsoft Access Database Engine 2010 Redistributable" from here: https://www.microsoft.com/en-us/download/details.aspx?id=13255  will allow you to use .xlsb directly.

[MarqueeCrew]

@Aguisande ,

 this post helped me give NJ the help she needs.  

thanks,

 mark

[Aguisande]

Thanks Mark!