Jitterbit · Database connector (ODBC Excel driver)

Operation must use an updateable query

Short answer

This Jitterbit error means the ODBC Excel driver opened the file read-only, because the connection string does not set read/write mode. In the Database connection's Connection String field, append ReadOnly=0; to the end of the string.

VerifiedLast verified

01Error text

Jitterbit error
[Microsoft][ODBC Excel Driver] Operation must use an updateable query

02Likely causes

  • The ODBC Excel driver opens the file read-only unless the connection string explicitly sets read/write mode.

03How to fix it

  1. In the Database connection's Connection String field, append ReadOnly=0; to the end of the string.

04Official documentation

Test every fix in a non-production environment before you apply it to production. See how entries are verified.

More for Jitterbit work:Open Jitterbit jobsJitterbit rates and salaries

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.