Describe XLSB files in Excel 2007
In this article i am going to explain about how to use xlsb files in excel 2007.
Xlsb files
This one is for connecting to Excel 2007 files with the Xlsb file extension. That is the Office Open XML format saved in a binary format.
|
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\sam007\myBinaryExcel2007file.xlsb;Extended Properties="Excel 12.0;HDR=YES";
|
"HDR=Yes;" indicates that the first row contains column names, not data. "HDR=No;" indicates the opposite.
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here