Hi,

I need to read data from excel worksheet which is protected by password. I know the password, how to pass the password in connection string. my connection string is

"DRIVER=Microsoft Excel Driver (*.xls);" & "DBQ=C:Test.xls"

Please help me. It will be very appreciable....

Thanks,
Jensen

Hi

this is the VB.NET forum

see this link for links to VB6 forums


http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/6a0719fe-14af-47f7-9f51-a8ea2b9c8d6b

Excel files protected by a password can only be opened via Excel. There is no support for Excel passwords when using the ODBC driveror Jet database engine.

---

Paul ~~~~ Microsoft MVP (Visual Basic)

Hi Jensen,

This isa VB.NET forum, for VB 6 questions, please see the list of resources here:http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/6a0719fe-14af-47f7-9f51-a8ea2b9c8d6b

---

Steve Hoag Microsoft aka the V-Bee

Hi,

I need to read data from excel worksheet which is protected by password. I know the password, how to pass the password in connection string. my connection string is

"DRIVER=Microsoft Excel Driver (*.xls);" & "DBQ=C:Test.xls"

Please help me. It will be very appreciable....

Thanks,
Jensen

Hi

this is the VB.NET forum

see this link for links to VB6 forums


http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/6a0719fe-14af-47f7-9f51-a8ea2b9c8d6b

Excel files protected by a password can only be opened via Excel. There is no support for Excel passwords when using the ODBC driveror Jet database engine.

---

Paul ~~~~ Microsoft MVP (Visual Basic)

Hi Jensen,

This isa VB.NET forum, for VB 6 questions, please see the list of resources here:http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/6a0719fe-14af-47f7-9f51-a8ea2b9c8d6b

---

Steve Hoag Microsoft aka the V-Bee