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.
2019-10-17
This article will show how to store images, document and all other files in SQL Table.
2017-12-07
15,392 reads
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?
2017-01-06
2,805 reads
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.
2009-06-09
5,083 reads
OPENROWSET is a handy tool for retrieving data. Find out how to use the OPENROWSET function for SQL Server and Microsoft Access.
2009-05-05
4,399 reads
OPENROWSET is a T-SQL function that allows for reading data from many sources including using the SQL Server’s BULK import capability.
2008-12-29
6,687 reads
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?
2008-08-14
4,696 reads
By Steve Jones
I am not a great software developer. I’m OK, and I do know how...
By Steve Jones
Today’s coping tip is to appreciate your hands and all the things they do...
By alevyinroc
On to the FIRST Robotics Competition 2023 World Championship Last week I wrote about...
Hi, each day we are sent an email with an XML attachment. Recently the...
SELECT BusinessEntityID,FirstName,MiddleName,LastName, YEAR(OrderDate) AS OrderYear, DATENAME(MM,OrderDate) AS OrderMonth FROM Person.Person Pp INNER...
I am after some advice, I have completed a SSRS migration 2017 - 2019. ...
Ask SSC