topic Connect to Excel to get Sheet Names - Connection Error in QlikView https://community.qlik.com/t5/QlikView/Connect-to-Excel-to-get-Sheet-Names-Connection-Error/m-p/819822#M667960 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I've got a excel spreadsheet that sits on PowerPoint.&nbsp; I've found code where I can create a connection to this document and then load a table</P><P></P><P>Example:</P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P>OLEDB</P><P></P><P><SPAN style="font-size: 8pt;"> </SPAN><STRONG style="color: #0000ff; font-size: 8pt;"><STRONG style="color: #0000ff; font-size: 8pt;">CONNECT32</STRONG></STRONG><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TO</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;"><SPAN>[Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=Excel Files;DBQ='</SPAN><A class="jive-link-external-small" href="http://urlandlocationinfoishere.xlsx';DriverId=1046;MaxBufferSize=2048;PageTimeout=5;">http://urlandlocationinfoishere.xlsx';DriverId=1046;MaxBufferSize=2048;PageTimeout=5;</A><SPAN>"]</SPAN></SPAN><SPAN style="font-size: 8pt;">; </SPAN></P><P></P><P>Temp_Tables:<BR />sqltables;</P><P></P><P>..</P><P>.</P><P>.</P><P></P><P>When it hits this excel connection, I get the following error, has anyone seen this or could anyone help?&nbsp; I'm stuck on this one:</P><P></P><P>ODBC Excel Driver Login Failed</P><P>Cannot update.&nbsp; Database or object is read-only.</P></BODY></HTML> Tue, 25 Nov 2014 20:49:56 GMT joshabbott 2014-11-25T20:49:56Z Connect to Excel to get Sheet Names - Connection Error https://community.qlik.com/t5/QlikView/Connect-to-Excel-to-get-Sheet-Names-Connection-Error/m-p/819822#M667960 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I've got a excel spreadsheet that sits on PowerPoint.&nbsp; I've found code where I can create a connection to this document and then load a table</P><P></P><P>Example:</P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P>OLEDB</P><P></P><P><SPAN style="font-size: 8pt;"> </SPAN><STRONG style="color: #0000ff; font-size: 8pt;"><STRONG style="color: #0000ff; font-size: 8pt;">CONNECT32</STRONG></STRONG><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TO</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;"><SPAN>[Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=Excel Files;DBQ='</SPAN><A class="jive-link-external-small" href="http://urlandlocationinfoishere.xlsx';DriverId=1046;MaxBufferSize=2048;PageTimeout=5;">http://urlandlocationinfoishere.xlsx';DriverId=1046;MaxBufferSize=2048;PageTimeout=5;</A><SPAN>"]</SPAN></SPAN><SPAN style="font-size: 8pt;">; </SPAN></P><P></P><P>Temp_Tables:<BR />sqltables;</P><P></P><P>..</P><P>.</P><P>.</P><P></P><P>When it hits this excel connection, I get the following error, has anyone seen this or could anyone help?&nbsp; I'm stuck on this one:</P><P></P><P>ODBC Excel Driver Login Failed</P><P>Cannot update.&nbsp; Database or object is read-only.</P></BODY></HTML> Tue, 25 Nov 2014 20:49:56 GMT https://community.qlik.com/t5/QlikView/Connect-to-Excel-to-get-Sheet-Names-Connection-Error/m-p/819822#M667960 joshabbott 2014-11-25T20:49:56Z