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.