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)
 Combining sheets of different excel into one

Author  Topic 

naveenjv
Starting Member

9 Posts

Posted - 2012-05-23 : 02:26:01
Hi,
Is there any way to combine single sheets of different excel into multiple sheets of single excel using TSQL coding?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2012-05-23 : 03:08:53
Is it absolutely necessary to do this in SQL Server ?


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

naveenjv
Starting Member

9 Posts

Posted - 2012-05-23 : 03:15:05
Yes.
Im currently generating the reports using system SP sp_makewebtask. It generates different excel files for each of the table. I wanted to merge some of these individual excels in to single excel with multiple sheets.
Go to Top of Page
   

- Advertisement -