SQLTeam.com | Weblogs | Forums

Excel WorkBook With Multiple excel sheets


#1

HI ,

I am exporting data from SQL server to existing Excel workbook.
Now I want to create new excel workbook with multiple excel sheets using SQL.
I Don't want to use IMPORT/EXPORT feature of SSMS.

Please let me know how to create excel workbook with multiple sheets.

Thanks.


#2

Integration services via SSDT-BI


#3

Thanks for your reply..

Please elaborate,
How can i use "Integration services via SSDT-BI"


#4

install ssdt-bi (google for the link), then follow the stairway series here:Intregration Services


#5

Actually, it would be a whole lot easier if you wrote stored procedures and or views in T-SQL and then wrote a workbook to use "External Data" to "auto-magically" load it. You'd also enjoy the benefit of being able to use Active Directory to control who has access to the data.