Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Errors
Opening Excel 2007 Binary Files (.xlsb) via OleDb ACE
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="Allan D, post: 2668386"] Hi Jan, Thank you for answering on this thread. It was Rafael who wrote. But Rafael and I get the same error-message. When i save an Excel file i use the mail-menu item called Save as... and then submenu item "Excel Binary Workbook". Then the Save as type, will be preselected to "Excel Binary Workbook (*.xlsb), i choose a filename, and press the button "Save" The same and other machines containing MS Office Excel 2007 can then read the .xslb file without any trouble. But not via the OleDbConnection. I get the Exception with only a few lines of code: Imports System.Data.OleDb Public Sub TestXlsb() Dim connStr As String = "Provider=Microsoft.ACE.OLEDB.12.0;" & _ "Data Source=D:\Myfile.xlsb;" & _ "Extended Properties=""Excel 12.0;HDR=NO;IMEX=1"";" Using conn As OleDbConnection = New OleDbConnection(connStr) conn.Open() 'this line throw an exception. End Using End Sub ...... to me this looks like a well-defined MS Office 2007 Bug. Don't you think so? Best Regards, Allan [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Errors
Opening Excel 2007 Binary Files (.xlsb) via OleDb ACE
Top