0 Replies Latest reply: Nov 25, 2014 3:49 PM by Josh Abbott RSS

    Connect to Excel to get Sheet Names - Connection Error

    Josh Abbott

      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.