Export SQL query data to Excel

by

I don’t know if this is what you’re looking for, but you can export the results to Excel like this:

In the results pane, click the top-left cell to highlight all the records, and then right-click the top-left cell and click “Save Results As”. One of the export options is CSV.

You might give this a shot too:

INSERT INTO OPENROWSET 
   ('Microsoft.Jet.OLEDB.4.0', 
   'Excel 8.0;Database=c:\Test.xls;','SELECT productid, price FROM dbo.product')

Lastly, you can look into using SSIS (replaced DTS) for data exports. Here is a link to a tutorial:

http://www.accelebrate.com/sql_training/ssis_2008_tutorial.htm

== Update #1 ==

To save the result as CSV file with column headers, one can follow the steps shown below:

  1. Go to Tools->Options
  2. Query Results->SQL Server->Results to Grid
  3. Check “Include column headers when copying or saving results”
  4. Click OK.
  5. Note that the new settings won’t affect any existing Query tabs — you’ll need to open new ones and/or restart SSMS.

More Related Contents:

  1. Using Excel VBA to run SQL query
  2. Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null
  3. NOT IN vs NOT EXISTS
  4. Most efficient way in SQL Server to get date from date+time?
  5. Using Excel VBA to export data to MS Access table
  6. How do I group on continuous ranges
  7. join comma delimited data column
  8. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  9. How to list files inside a folder with SQL Server
  10. is it possible to select EXISTS directly as a bit?
  11. How to quickly edit values in table in SQL Server Management Studio?
  12. Database Naming Conventions by Microsoft?
  13. Functions vs Stored Procedures
  14. Why & When should I use SPARSE COLUMN? (SQL SERVER 2008)
  15. Convert date to YYYYMM format
  16. How to get results in a custom order? [closed]
  17. Optimizing Delete on SQL Server
  18. Conversion failed when converting the varchar value ‘simple, ‘ to data type int
  19. Is there a quick way to check if ANY column is NULL?
  20. Using CASE Statement inside IN Clause
  21. Combine Two Tables in Select (SQL Server 2008)
  22. SQL Convert Week Number to Date (dd/MM)
  23. Ambiguous column name error
  24. SQL query for parent-child chain
  25. Single or multiple databases
  26. SQL Unpivot multiple columns Data
  27. Call stored procedure with table-valued parameter from java
  28. T-SQL Conditional Order By
  29. How to group by a Calculated Field
  30. Is there an Oracle equivalent to SQL Server’s OUTPUT INSERTED.*?

Leave a Comment