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

Thanks in advance.

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

http://www.erlandsendata.no/english/...odao/index.php

--
Regards,
Tom Ogilvy

cribeiro wrote in message
...
How to use Jet Oledb Provider to read data from a protected Excel
workbook?

Thanks in advance.

Missed the qualification that the workbook was protected.

Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
See Mr. Erlanden's page for some example code:

http://www.erlandsendata.no/english/...odao/index.php

--
Regards,
Tom Ogilvy

cribeiro wrote in message
...
How to use Jet Oledb Provider to read data from a protected Excel
workbook?

Thanks in advance.

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

"cribeiro" wrote in message ...
How to use Jet Oledb Provider to read data from a protected Excel workbook?

Thanks in advance.