Apply the Openrowset Function to Acquire Rowsets

In the previous blog on SQL Server’s OPENROWSET function we observed that while OPENROWSET is most often encountered in relation to linked servers, it is also valuable for directly reading flat files. It’s worth taking a moment to mention another less common application of OPENROWSET ( ). If you wanted to write code that returned […]
Read More ›

Using OPENROWSET to Read Excel Worksheets from SQL Server: Part 2 – How to Define and Query a Linked Server

In my last post we looked at how to set up the system to use OPENROWSET to read Excel Worksheets from SQL Server. I believe that using the OPENROWSET function is the most flexible and practical method for linking Excel worksheets to SQL Server. Before we look at OPENROWSET, however, let’s take a moment to review […]
Read More ›

Using OPENROWSET to Read Excel Worksheets from SQL Server: Part 1 – How to Set Up the System

Julia P. from the Learning Tree Transact-SQL Programming course writes “I’ve tried to use the OPENROWSET function to query Excel files, but I keep getting the same error. No matter what I try, SQL Server responds with “OLE DB provider “Microsoft.Jet.OLEDB.4.0” for linked server “(null)” returned message “Could not find installable ISAM.”.” Hi, Julia. Unfortunately,lots […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.