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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to Fix Damaged Excel File That Won't Open? 3
Excel Unlink open excel files 2
Excel Opening Problems ? And, Other Equiv Spreadsheets ? 1
How to Unlock Excel Workbook protected by MACRO Password 6
How to get a file from a web page 1
Windows 10 New Win 10 File Explorer 2
Excel Permissions 1
Excel How to Repair Excel Files? 1

Back
Top