Xlsb files using Microsoft.ACE.OLEDB.12.0

Connection string

This Microsoft ACE OLEDB 12.0 connection string can be used for connections to Excel 2007, Excel 2010 and Excel 2013.

Connect to Excel 2007 (and later) files with the Xlsb file extension. That is the Office Open XML format saved in a binary format. I e the structure is similar but it's not saved in a text readable format as the Xlsx files and can improve performance if the file contains a lot of data.

Provider=Microsoft.ACE.OLEDB.12.0;
Data Source
=c:\myFolder\myBinaryExcel2007file.xlsb;

Extended Properties
="Excel 12.0;
HDR=YES";

You can also use this connection string to connect to older 97-2003 Excel workbooks.

"HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.