Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Pasi
Posting Yak Master
166 Posts |
 Posted - 2014-05-01 : 13:15:33
|
Hi Gurus,how do I export data from dB to excel , note, etc? is there a query to do this? does it have to be in form of tabular, like excel or can it be exported into other formats?Thanks!Pasi |
|
|
sqlsaga
Yak Posting Veteran
93 Posts |
Posted - 2014-05-01 : 15:29:20
|
| You can either use import and export wizard or use SSIS to do this..Right click on the database and select Tasks.Click on Import Data / Export Data.Select the source and destination as required.And your requirement is done.Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles. |
 |
|
|
Pasi
Posting Yak Master
166 Posts |
Posted - 2014-05-01 : 17:18:04
|
| Thank you I 'll try that!Pasi. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
Pasi
Posting Yak Master
166 Posts |
Posted - 2014-05-02 : 11:31:10
|
| Thank you jack!Pasi |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-05-07 : 13:07:28
|
| your welcomeJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
how to export to wrod, excel