Hello, guys. In this article we will see how to export data from database to excel and vice versa using OPENROWSET() function.
We need to set up OPENROWSET in the server. Below i'll show how i did it, but it's not necessary helps in your situation.
Open sql server configuration manager - > SQL SERVER - > change to "local system"
Now it should works
Hello, guys. In this article we will see how to export data from database to excel and vice versa using OPENROWSET() function.
- We need to set up OPENROWSET in the server. Below i'll show how i did it, but it's not necessary helps in your situation.
- Open sql server configuration manager - > SQL SERVER - > change to "local system"
- Now it should works