Popular Posts

  • Error: 18056, Severity: 20, State: 23
    SQLServerCentral » Latest topics Error: 18056, Severity: 20, State: 23 Hi.. Error: 18056, Severity: 20, State: 23. Message The clie...
  • sp_helpindex2
    SQLblog.com - The SQL Server blog spot on the web sp_helpindex2 --my extension of sp_helpindex: sp_helpindex2 USE master GO IF EXIS...
  • XML parsing: semicolon expected
    SQLServerCentral » Latest topics XML parsing: semicolon expected I know the "XML parsing: semicolon expected" error is a ...

SQLblog.com - The SQL Server blog spot on the web

Loading...

Monday, March 19, 2018

OPENROWSET and "Could not find installable ISAM"

SQLServerCentral » Latest topics
OPENROWSET and "Could not find installable ISAM"
Hi Folks,

I have a problem with regards to querying an Excel Spreadsheet using not only OPENROWSET but also OPENDATASOURCE.

I am using SQL Server 2016, the spreadsheet is Excel 2010.

This is the OPENROWSET statement:
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)