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 |
|
temperature
Starting Member
5 Posts |
 Posted - 2008-06-19 : 20:27:24
|
| Hello everybody,I am new to this forum and I dont know much about MS SQL Server and SQL Language at all. Anyway, I just wrote a SQL Script (Query) that pulls one sql table from a large database. Because I need this script for many similar cases (only one parameter changes), I will write a java program which produces the specific sql code with respect to the particular situation. Thus my Query will produce many tables. How can automate to export each of them in an excel? It can not be the case that I have to build a excel file for each sql-table manually. The SQL Script should produce the excel file automaticly. My question for short:"select * from final"how can i export the resulting table to an excel file (which should be built by ms sql server in exactly this moment)?Thanks a lotTemperature |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-19 : 22:28:38
|
| Check Export/Import wizard in Books online that comes with SQL Server. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-20 : 15:19:35
|
| Refer this too:-http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926 |
|
|
|
|
|
|
How to export many tables to MS Excel?