ODBC Excel Driver Error - ErrorMsg: [Microsoft][ODBC Excel Driver] Cannot update. Database or object is read-only.

[Anonymous]

Hello All

Qlik Sense Edition: November 2017 (Server 11.24.1)

Windows Version: Windows Server 2012 R2 Standard (64 Bit)

Windows Build: 9600

I am currently in the process of utilising a script which uses the "Microsoft Access Database Engine 2010" ODBC 64-bit driver to get a table list of Sheets which belong to a Microsoft Excel workbook. However, the ODBC Driver fails to connect to the spreadsheet file due to the following error message:

Connector connect error: SQL##f - SqlState: 42000, ErrorCode: 4294965487, ErrorMsg: [Microsoft][ODBC Excel Driver] Cannot update. Database or object is read-only.

For Each vFile in FileList('$(ReportDirectoryVechAct)')

    ODBC Connect To [Excel Files;DBQ=$(vFile)];

    Sheets:

    LOAD *,

    Replace(TABLE_NAME, chr(39), '') as Purge;

    SQLTABLES;

    DISCONNECT;

/// CONTINUED

Variable Examples:

• ReportDirectoryVechAct: 'lib://Data Sources (*****)/Reporting Email\Vehicle Activity\*.xls'
• vFile: 'lib://Data Sources (*****)/Reporting Email\Vehicle Activity\28C0608581D54C088846C22A01B23B6E@mmslocal-5227_VehicleActivityDetailReport.xls'

I have tried the following solutions:

• Uncheck "Read Only" in ODBC Driver settings, and add "READONLY=TRUE" parameter to ODBC creation.
• Disabled "Standard Mode" in QMC
• Attempted to use both 32 Bit and 64 Bit Drivers

Any help would be much appreciated.

[leonid_burlakov]

Most likely, the problem is in the name of the Excel file. If there are characters () that give an error. How to solve I don't know. Check if there is no () characters is ok?

[howiekrauth]

I'm having this same issue.  Removing special characters from the excel file name works, but this is not an option for my client.

It seems if the client has an older version of the ACEODBC driver installed (Version 15), all is fine, but with a newer version of the ACEODBC driver (Version 16), an error is thrown.

If anyone has any other options for this, please let me know.  Thanks!

[amars]

Hi Larran

Did you find any solution for this, I am also facing similar issue when upgrading from 11.2 to Nov 2018 version.

Thanks in advance.

Best Regards

Amar