Tag Archives: Excel

Drawing in Excel

I wrote a VBA module for Excel over five years ago for clients. It has a User Interface in Excel which imports CSV data from one of our software packages and then creates scatter plots on a separate worksheet using … Continue reading

Posted in Miscellany | Tagged , , , | 1 Comment

Using Excel to create an html FAQ

Like Generating SQL from Excel, you can do the same for HTML files. One task I’ve automated is the building of Frequently Asked Question files. The kind with a short list of questions and these are linked below to the … Continue reading

Posted in Miscellany | Tagged , , , | Leave a comment

Improved SQL Server Index Scripting from Excel

I covered Index Scripts using Excel in an earlier post but I was obliged to make my spreadsheet do more over the past few workdays. Basically I needed to allow multiple indexed fields and multiple included fields. The following solution … Continue reading

Posted in Miscellany | Tagged , , | 1 Comment

Generating Index scripts for SQL Server 2005 in Excel

So, I go further in my series of blogs on automating SQL Server 2005 scripting. This time its the tool of the performance sensitive DBA: the nonclustered index. These are pretty straightforward and should be easy to implement.  The first … Continue reading

Posted in Miscellany | Tagged , , , | 2 Comments

Using Excel to generate Inserts for SQL Server

Much of my day job involves database design, maintenance and manipulation. I use SQL scripts to quickly build my databases from scratch. In order to test them I need piles of data and find it is often too much work … Continue reading

Posted in Miscellany | Tagged , , , , | 32 Comments