Export more than 500 tables data in 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

SQL Server 2005 Forums

SQL Server Administration (2005)

Export more than 500 tables data in Excel file

Author

Topic

netrapalg
Starting Member

3 Posts

Posted - 2009-07-27 : 00:45:42

Hi,
can anybody tell me that how can i export more than 500 tables data in excel file.i am using sql server2005.

Netra Pal
SAP Consultant

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2009-07-27 : 01:49:48

Hey try this it may helpful for u

Exec sp_MsForEachTable 'Exec Master..xp_cmdshell "bcp [concourse].[dbo].

out C:\?.xls -c -T"'

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

http://senthilnagore.blogspot.com/

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-07-27 : 01:58:45

Hi Netra Pal

Refer this....
http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1306800,00.html

-------------------------
R..

ahmad.osama
Posting Yak Master

183 Posts

Posted - 2009-07-27 : 07:11:53

quote:
Originally posted by senthil_nagore

Hey try this it may helpful for u

Exec sp_MsForEachTable 'Exec Master..xp_cmdshell "bcp [concourse].[dbo]. out C:\?.xls -c -T"'

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

http://senthilnagore.blogspot.com/

it is not working

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources