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.