how to move the data from db to an excel file

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.

All Forums

General SQL Server Forums

Data Corruption Issues

how to move the data from db to an excel file

Author

Topic

saikiran
Starting Member

10 Posts

Posted - 2013-03-23 : 02:33:39

can anybody please tell me the exact procedure to move the data from table to excel sheet

sai

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-03-23 : 17:19:41

There is some information here http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=49926
You can also use SSIS or Import/Export Wizard (right-click on the database name in SSMS object explorer and select Tasks -> Export Data

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-03-24 : 11:53:06

another option is to OPENROWSET or bcp

see

http://beyondrelational.com/modules/2/blogs/70/posts/10792/importexport-to-excel.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-03-25 : 02:45:11

Powershell is an another option - this link gives you an example : http://www.sqlserver-dba.com/2011/07/powershell-sql-server-security-audit.html.

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

saikiran
Starting Member

10 Posts

Posted - 2013-03-28 : 08:23:27

thanks a lot for your replies

sai

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-03-28 : 10:41:06

welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources