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.