Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 224
  • Last Modified:

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?


Thanks
0
jaymz69
Asked:
jaymz69
1 Solution
 
Nico BontenbalCommented:
You could use this technique:
http://www.mssqlcity.com/Articles/General/OleAutSP.htm

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

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now