Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
howiekrauth
Partner - Contributor III
Partner - Contributor III

ODBC Error connecting to Excel in QlikView 12

Hello all,

I'm upgrading a user from QlikView 11 to QlikView 12.

When I run the load script, I get an error:

ODBC Excel Driver Login Failed

Cannot update.  Database or object is read only.

If I remove special characters from the excel file name, the load runs fine.  This is not an option for the user.

Can anyone help?

Thanks!

1 Reply
howiekrauth
Partner - Contributor III
Partner - Contributor III
Author

Some more context:

This does not work:

ODBC CONNECT32 TO [ForecastData;DBQ=C:\QVW\Data\Excel\Share\Forecast\Aqua-1 (Irina).xlsx];

This works:

ODBC CONNECT32 TO [ForecastData;DBQ=C:\QVW\Data\Excel\Share\Forecast\Aqua1Irina.xlsx];