January 18, 2010 at 11:52 pm
How To export To Excel data From Database in sql server 2005
January 19, 2010 at 12:05 am
Right click on the database in SSMS , tasks->export/import wizard->export to excel.
Regards,
Raj
January 19, 2010 at 7:42 am
You can save the package at the end of the import export wizard in case you intend to use it later on.
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 19, 2010 at 1:21 pm
... or you can set up an XLS file as a linked server
... or you can use SSIS
... or bcp
... or send an email with the data attached as xls file
... or ... (I'm sure there are more options)
It all depends on your requirements. There are several ways to do it.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply