Not directly in T-SQL. Normally export is handled using SSIS or similar tool.
XSLX follows the Office OpenXML specification and ultimately is a ZIP file. T-SQL can generate text files but it isn't going to be able to generate an OpenXML document.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
Using tSQl is it possible to export to .xlsx format (Excel)... I'm looking to export from a table or view.
I have googled and read a few blogs on similar lines but they seam to work for .xls format only...
Any help or pointers will be highly appreciated.
Not directly in T-SQL. Normally export is handled using SSIS or similar tool.
XSLX follows the Office OpenXML specification and ultimately is a ZIP file. T-SQL can generate text files but it isn't going to be able to generate an OpenXML document.