Microsoft.ACE.OLEDB.12.0Xlsb files

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.

Connecting

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

Articlesread all »

Not the right connection string for you?

Start over in the connection string reference index.

You can also get help in the Q&A forums where you can ask your own question.

The kb articles contains how-tos and instructions and you can search for anything if you're not sure were to look.