very persistent "Could not find installable ISAM" error

[HBovenkamp]

Good day,

I keep running into a very persistent "Could not fine installable ISAM" error when trying to connect to an Excel sheet (office 2010) by opening an OledbConnection

Here's my connection string:

Dim strCon As String
strCon = "Provider=Microsoft.ACE.OLEDB.12.0;ACE OLEDB:Database Password=" & strEnter & ";Data Source= " & strExcel & ";Extended Properties=""Excel 12.0 xlsx"";"

MyConnection = New System.Data.OleDb.OleDbConnection(strCode)

Everythin I've read sofar points to the connection string as the cause of the exception, but try as I may I can't get it to work.

Any assistence or pointer into the right direction will be greatly appreciated.

Kind regards

[kRod]

Try this

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES";

[Click Here](http://www.connectionstrings.com/excel-2007#ace-oledb-12-0)

[HBovenkamp]

Thanks kRod, that works fine, however it goes wrong again when I want to open a password protected xlsx file.

ACE OLEDB:Database Password=" & strEnter & ";

This is when I run against the "uninstallable ISAM" error.
Do you have any suggestions? I couldn't find anything on (http://www.connectionstrings.com/excel-2007#ace-oledb-12-0) on this subject.

Appreciate your help

[kRod]

try this.

Provider := Microsoft.ACE.OLEDB.12.0;Data Source="C:\temp\MyExcel.xlsx";Extended Properties="Excel 12.0 Xml;HDR=YES;“;Jet OLEDB:Database Password=”";

[HBovenkamp]

That works, You're a live saver!!!
Thanks