SQL 2008 r2 and Excel

In VFP it is called Excell Automation (codeing in the program to create the excel object and change the excel properites around...  Highlight rows, add filter button, adjust to fit...)

Is there a way to do that in SQL Server 2008 r2?

Who is Participating?
Nico BontenbalCommented:
You could use this technique:

But you might be better of creating a vb script that connects to SQL Server and uses the Excel Automation.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.