Excel file permissions problem

  • Thread starter Thread starter Nikolay Petrov
  • Start date Start date
N

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
 
¤ 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)
 
Back
Top