Script to export data frmo SQL Server 2014 to xls file

Ok, I have downloaded the exe from the above link.

As I have to install this on a production environment, I want to be sure of certain things ...

Say I have installed the Provider, what would be the syntax for exporting the data from sql server 2014 to xls.

It would certainly not be the same ... i feel.. please let me know.

Thanks

Yes

provider connection string would be different

like

INSERT INTO OPENROWSET("Microsoft.ACE.OLEDB.12.0", "Excel 12.0;Database=<full file name>.xlsx;HDR=YES", "SELECT * FROM [SheetName$]") 
SELECT ..
FROM table

---

Please Mark This As Answer if it solved your issue

Please Mark This As Helpful if it helps to solve your issue

Visakh

----------------------------

My MSDN Page

My Personal Blog

My Facebook Page