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
Go to Top of Page

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/

Go to Top of Page

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
Go to Top of Page

saikiran
Starting Member

10 Posts

Posted - 2013-03-28 : 08:23:27
thanks a lot for your replies


sai
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

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

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

Go to Top of Page
   

- Advertisement -