Hi @vasundhara.sharma, I wrote chatgpt for using xlsb format and it’s answer below down.
Unfortunately, the ACE.OLEDB.12.0 provider does not natively support .xlsb (Binary Excel) files. While it works with .xls and .xlsx formats, you need to use alternative methods to handle .xlsb files.
Summary:
If Excel is installed and converting the file format is not an option, the easiest solution is to use the Excel Application Scope activity. Directly working with .xlsb files using OLEDB is not supported.