I need use ODBC to access a excel file (.xls) which is password protected. I use ODBC string
"Driver=....; DBQ=file1.xls; pwd=pass1", I got message the file can not be decrypted.
Please help.
Thanks
ODbc Connection String to Excel
Hot Topic
- Marshalling COM interface between threads--help!
- Simple Question Regarding VB and MS Access
- How to easily load data from an XML doc?
- TransactionScope, ADO.NET, and Timeouts
- Tracing to a file from a pooled webservice
- Encryption woes
- Easy way to combain VB.NET and C#
- COM interop to unmanaged OO COBOL component returns 0x8002003
- How to pass the command to the other executable file?
- Just first access, SerializationException: Unable to find assembly
.NET Development
- Save and Load with XML
- WSE2.0 occasionally stops working with a WSE402 error
- .net framework 2.0 and sql & vwd installation driving me to drink-or worse!
- Problem when starting two listening sockets simultaneously
- how to send SMS to mobile from pc via webservice
- Security for new serial port class
- Multiple async calls to 2 different web service methods
- Call to NetworkStream.read not blocking Intermittently
- Convert xls to csv programmatically (and back again)
- Convert string to SystemColor?
ODbc Connection String to Excel
murratore
211378 (http://support.microsoft.com/kb/211378/EN-US/) XL2000: "Could Not Decrypt File" Error with Password Protected File
Just from the KB article, if your scenario would allow launching Excel to open the file, there might be a workaround somewhere, but that might also require manual password entry by a user.