How to automatically report an SQL query into an Excel spreadsheet in regular intervals

Question

I am currently working on an application that is meant to be relaying realtime data on screens. I would like to know how to automatically report the resultset of a SQL query to a Microsoft excel sheet using SQL Server 2005.

Many thanks for your audience and anticipated help.

Cheers, Tunde

APC · Accepted Answer · 2010-12-04 08:59:06Z

1

Probably the simplest way of exporting from SQL Server to Excel in TSQL with OPENROWSET. Find out more.

Then schedule the running of the TSQL using SQL Server Agent.

answered Dec 4, 2010 at 8:59

APC

147k20 gold badges180 silver badges289 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Fionnuala Over a year ago

Excel is quite happy to open CSVs and I think SQL Server is quite happy to export CSVs

Koekiebox · Accepted Answer · 2010-12-04 08:53:50Z

0

The best would be to write a program Or even a excel Plugin in .net that writes your query result to a csv file at certain intervals that you can open with excel.

answered Dec 4, 2010 at 8:53

Koekiebox

5,97114 gold badges56 silver badges88 bronze badges

Collectives™ on Stack Overflow

How to automatically report an SQL query into an Excel spreadsheet in regular intervals

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related