Excel file permissions problem

microsoft.public.dotnet.framework.adonet

30 Mar 2005 7:09 AM

Nikolay Petrov

I have an Excel file, which I use to store some data.
When reading from file, everiting is ok.
When i try to insert some row, an OleDbExcetpion is thrown.
I'va tracked it to a permission problem.
The sheats of my Excel file as protected with password.
Any way I can supply this password to the connection string, or other way?

thanks

30 Mar 2005 2:29 PM

Paul Clement

On Wed, 30 Mar 2005 10:09:34 +0300, "Nikolay Petrov" <johntup2_nospam_@mail.bg> wrote:

¤ I have an Excel file, which I use to store some data.
¤ When reading from file, everiting is ok.
¤ When i try to insert some row, an OleDbExcetpion is thrown.
¤ I'va tracked it to a permission problem.
¤ The sheats of my Excel file as protected with password.
¤ Any way I can supply this password to the connection string, or other way?

Unfortunately there is no support for working with native Excel password protection via OLEDB or
ODBC data access.

Paul
~~~~
Microsoft MVP (Visual Basic)