Updating excel file using OleDbCommand produces the error "Operation must use an updateable query" RRS feed

  • Question

  • User-1052995518 posted


    I'm usuing OleDbCommand to update a cell in an excel file, I keep getting the error "Operation must use an updateable query".

    I tried giving everyone permission on the excel file, also tried some suggestions online.

    Any one has an idea what the problem is ? 

    Thanks & Regards,

    Sunday, August 3, 2014 12:55 AM


  • User-821857111 posted

    You need to give the user account MODIFY permissions on the folder that the file is in as well as the actual file. The user account is either NETWORK SERVICE, IUSR_YourMachineName or IIS APPPOOL\NameOfYourApppool.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, August 3, 2014 4:05 AM