Jet Ole DB With Excel

[cribeiro]

How to use Jet Oledb Provider to read data from a protected Excel workbook?

Thanks in advance.

 

[Tom Ogilvy]

See Mr. Erlanden's page for some example code:

http://www.erlandsendata.no/english/vba/adodao/index.php

 

[onedaywhen]

You cannot use ADO/DAO to read a password-protected Excel workbook. The
reason is that protecting it with a password actually encrypts the
workbook on disk and ADO/DAO has no way of decrypting it. See the
following MSDN article:

Microsoft Knowledge Base Article - 211378
XL2000: "Could Not Decrypt File" Error with Password Protected File
http://support.microsoft.com/?KBID=211378

 

[Tom Ogilvy]

Missed the qualification that the workbook was protected.

Regards,
Tom Ogilvy