how to read a passward protected excel file with the help of database connectivity tool kit

[sumitra Mundel]

hi, i was reading an excel file with the help of database connectivity tool kit in labview 8.0

i made tabels in the excel file nand made odbc connection and specified the workbbok name.

now my problem is how to read the same file if i specife a pasword to that excel file ?

[Amanda_H]

Hi,

Check out this thread about opening a password-protected Excel file using ActiveX. This should take care of it for you!

[tst]

Or try searching Excel related sites to see how Excel functions as an ODBC data source. Presumably Microsoft has an official way of doing it (or an official "you can't do it" answer).