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
 SSIS and Import/Export (2005)
 Create an Excel file using SQL Query

Author  Topic 

srinivas.alwala
Starting Member

30 Posts

Posted - 2008-08-22 : 05:21:20
Hi,

I would like to create an excel file using sql statements.

The query should check whether the file already exists it should delete and create that file.

If anybody has a solution for the same, kindly let me know.

Regards,

Srinivas Alwala

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-22 : 05:48:23
you could simply achieve this using SSIS package. just use OLEDB source and Excel destination connections.
Go to Top of Page
   

- Advertisement -