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:
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:
No comments:
Post a Comment