Exporting SQL Server Data to Excel
- Execute any SQL query and save the results
directly to an excel spreadsheet.
- Run multiple queries and save the data to a single Excel
spreadsheet, each recordset to its own worksheet.
Exporting SQL Server Data to Delimited Files
- Export one table at a time, or...
- Export data from multiple tables at once.
- Export data as csv (just select comma as a the delimiter and give
the file the extension .csv).
- Export data where you have total control over choosing the column
delimiter.
|
Watch these scenarios. They are live demonstrations that take about
a minute each to run.
How
to export many queries to a single spreadsheet?
How to run a
query and send results directly to an excel spreadsheet?
How
to export table data to delimited files?
For SQL Server 2005, 2000, and 7.0
|
