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
 SQL Server 2005 Forums
 Transact-SQL (2005)
 export database tables from sqlserver to excell

Author  Topic 

sreedharkommuru
Starting Member

1 Post

Posted - 2008-09-21 : 00:24:01
i have more than 50 database tables in sqlserver. i want to send all those tables to excel spread sheet at once. so please tell me the procedure to send those tables. can i import using ms-excel? or is it possible to export from sql server?
please reply me as early as possible
thanking you



Sreedhar.k

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-21 : 02:59:20
use
1.SSIS or
2.OPENROWSET
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-09-21 : 07:12:55
moved from script library.

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-09-21 : 10:10:28
With Export/Import wizard.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-09-22 : 01:57:32
Union all the tables and use
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -