Connect to Excel to get Sheet Names - Connection Error

[joshabbott]

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.