SQL SERVER – 2005 – Export Data From SQL Server 2005 to Microsoft Excel Datasheet | Journey to SQL Authority with Pinal Dave

Enable Ad Hoc Distributed Queries. Run following code in SQL Server Management Studio - Query Editor. EXEC sp_configure 'show advanced options', 1; GO RECONFIGURE; GO EXEC sp_configure 'Ad Hoc Distributed Queries', 1; GO RECONFIGURE; GO Create Excel Spreadsheet in root directory c:\contact.xls (Make sure you name it contact.xls). Open spreadsheet, on the first tab of… Continue Reading...

Source: SQL SERVER – 2005 – Export Data From SQL Server 2005 to Microsoft Excel Datasheet | Journey to SQL Authority with Pinal Dave