OPENROWSET DNR

Read Excel File in SQL Server with OPENROWSET or OPENDATASOURCE

In this tip we look at how to read an Excel file from within SQL Server using OpenRowSet and OpenDataSource along with the possible errors you may encounter and how to fix these issues.

How to store Excel files In SQL Table

This article will show how to store images, document and all other files in SQL Table.

SQL Server Ad Hoc Access to OLE DB Provider Has Been Denied Error

I was trying to use OPENROWSET to query a remote database and I experienced the following error "Ad hoc access to OLE DB provider has been denied. You must access this provider through a linked server". When I ran this same query using a sysadmin account it worked fine. Why doesn't this work for other logins?

Dynamic SQL execution on remote SQL Server using EXEC AT

In this tip I am going to start my brief discussion with OPENQUERY and OPENROWSET table functions, its limitation and how the new EXEC AT command overcomes them.

Using the OPENROWSET function in SQL Server

OPENROWSET is a handy tool for retrieving data. Find out how to use the OPENROWSET function for SQL Server and Microsoft Access.

Using OPENROWSET to read large files into SQL Server

OPENROWSET is a T-SQL function that allows for reading data from many sources including using the SQL Server’s BULK import capability.

Using SQL Servers OPENROWSET to break the rules

Many times I would like to insert the results of a stored procedure into a table so I can do some extra processing with the result set. I always have to create the table first in order to perform an Insert Into Exec on the desired stored procedure since Exec Into is not an option. Is there a way to do this without having to manually create the table each time?