Q: Export to Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JIM.H. - 19 Jul 2008 23:35 GMT

Export to Excel
I would like to run a query in SQL Server 2005 and export the result set to
excel automated, how can I do this?

Reply to this Message

Linchi Shea - 20 Jul 2008 00:16 GMT

One approach is to use IMport/Export wizard in management studio to create a
simple SSIS package with the source being the query and the destionation
being an Excel file. And then schedule to run this package.

Linchi

> Export to Excel
> I would like to run a query in SQL Server 2005 and export the result set to
> excel automated, how can I do this?

Reply to this Message

Uri Dimant - 20 Jul 2008 08:06 GMT

JIM
You can create alinked server to Excel file (see BOL)

> Export to Excel
> I would like to run a query in SQL Server 2005 and export the result set
> to
> excel automated, how can I do this?

Reply to this Message