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 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Exporting Data from SQL to Excel in Multiple Files

Author  Topic 

Rusty0918
Starting Member

9 Posts

Posted - 2006-08-07 : 19:03:54
I'm trying to figure out how to query data from tables in SQL Server and then sending the data to multiple spreadsheet files. Essentially, the database has survey data from schools, and I want to break it down so that each Excel file has a certain school's information. The data is in four tables, and each Excel file has their own instances of these four tables, each containing only the information for that specific school.

Rusty0918
Starting Member

9 Posts

Posted - 2006-08-11 : 07:45:49
Guys, I really need help on this!!!!
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-08-11 : 13:02:28
See if this helps
http://sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

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

- Advertisement -