excel ADO connection string
Posted on 2014-03-05
when attempting to read data from and encrypted xlsx using:
dbConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" & SourceFile & "';Extended Properties=Excel 12.0;"
I get an error:
Error -2147467259, External table is not in the expected format. occurred in GetRecordsetFromClosedWorkbook
The error goes away when the file is not encrypted.
adding ;Database Password =test; to the connection string gives a different error:
Error -2147467259, Could not find installable ISAM. occurred in GetRecordsetFromClosedWorkbook
When I use Excel Open (with password) and copy/paste methods all is good
How does one add Excel encryption password to the ADO connection string?