Last post Jun 11, 2018 02:03 AM by Deepak Panchal
Jun 10, 2018 09:42 AM|JagjitSingh|LINK
Below statement is giving error
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'SELECT * FROM [SheetName$]') select * FROM [DB].[dbo].[Tbl_Test].
Is it possible thru above statement that it should insert data in excel from 4 column.
Jun 11, 2018 02:03 AM|Deepak Panchal|LINK
Try to run statement below.
sp_configure 'show advanced options',1
After that, Try to run statement below.
sp_configure 'Ad Hoc Distributed Queries',1
Then run the 'sp_configure'
It should give you output below.
Then after you can try to run your query.
SQL Server blocked access to STATEMENT
'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration
SQL Server blocked access to STATEMENT ‘OpenRowset/OpenDatasource’
Other thing I have noticed that you are not marking the suggestions as an answer in many threads.
As a result, Those threads are pending on our side.
I suggest you to mark the answer in your all threads if your issue is solved.
If issue is still exist then try to follow up those threads.
We will try to provide further suggestions to solve the issue.
It can help us to close those threads and solution can be helpful to other community members in future.
Thanks for your understanding.