An excellent discussion on manipulating Excel Spreadsheets directly from SQL Server TSQL!
http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/
Advertisements
Sections
-
Recent Posts
- Visual Studio 2012 puts the “Ug!” in “Ugly”
- What a Year Brings
- Installing Sharepoint 2010 Farm on a Single VMWare VM
- Access 2010: A Rare Second Chance
- Waaaay too busy to post….
- I’ll just leave this here…..
- Can’t Save Sharepoint Doc Even with proper permissions
- Can I Kick It? Yes I Can!
- Lessons Learned from a Cheese Curd maker
- I’ll just leave this here….
- So You Want To Be An Air Traffic Controller?
- A Toast to Brent!
- Does “Denali” portend the end of OLAP?
- Anti-Oopsie Tip of the Day
- The database principal is set as the execution context of one or more procedures, functions, or event notifications and cannot be dropped.
- That DBA Look…
- TSQL Cursor Options
- 2008 != 2008R2
- SSMS Tab Bar is Nearly Useless
- I Cannot Believe How Buggy MS Access Has Become!
1. The Daily Reading List
- Aaron Bertrand
- Adam Machanic
- Brent Ozar – Too Much Information
- David Bermingham
- David Stein – Made2Mentor
- DBA Survivor
- John Sansom, DBA
- Jonathan Kehayias – Rambling DBA
- Matt Whitfield
- Paul Ibison – Replication Answers Blog
- Simon Sabin
- Simple Talk
- SQL Blog Rankings
- SQL in the Wild
- SQL Skills
- SQLServerPedia
2. FOSS
