Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

joshabbott
Not applicable

Connect to Excel to get Sheet Names - Connection Error

Hello,

I've got a excel spreadsheet that sits on PowerPoint.  I've found code where I can create a connection to this document and then load a table

Example:

 

OLEDB

CONNECT32 TO [Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=Excel Files;DBQ='http://urlandlocationinfoishere.xlsx';DriverId=1046;MaxBufferSize=2048;PageTimeout=5;"];

Temp_Tables:
sqltables;

..

.

.

When it hits this excel connection, I get the following error, has anyone seen this or could anyone help?  I'm stuck on this one:

ODBC Excel Driver Login Failed

Cannot update.  Database or object is read-only.