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.
| Author |
Topic |
|
soer
Starting Member
1 Post |
 Posted - 2008-08-07 : 00:50:34
|
| Hi, Im running MSFT SQL Server Mgmt Studio 2005 and would like to export all the tables in a DB where the # of rows > 0. I would like to export all tables to individual XLS files. I've gone through BCP documentation to no avail. Is there a simple code that can just export all tables in a database (with # rows > 0) to individual XLS files? It should be noted that the tables I want to output to XLS are created dynamically by a script. So, I wont know the table names until after running said script and the code I'm asking for in this post should not require one to know the table names. Thank you in advance for all helpful responses! Please let me know if I need to be more clear in my request. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-08-07 : 00:52:02
|
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
Table to XLS