The points below gives you a brief overview of the SQL Drill add-in (version 1.4).

- SQL Drill is a Microsoft® Excel® based add-in that makes it easy to run SQL Queries right from Excel® .

- SQL Drill integrates into Excel® 2000, 2002(XP), 2003 and 2007.

- The add-in is actively supported (mainly though forums). The main support page is here: SQL Drill Support Link.

- SQL Drill is availalbe in free and "standard" versions. No tricks - No Ads, No Spyware, No Viruses  No "Phone Home". The free version needs to be re-installed every 6 months. By purchasing the standard version (US$ 59) you help support the add-in.

- SQL Drill adds easy database access to Microsoft® Excel® . SQL Drill has a very easy to use interface and will only take minutes to set up and start to use.  After installing, an Extra Excel Toolbar will be added to your Excel.  This toolbar holds 1 dropdown combobox and 4 different buttons and gives you access to all of the functionality of the Add-in.  The combobox will hold your available connections and can be used to quickly connect to and view the available selectable objects within a database.

- SQL Drill can connect to all standard databases so you can easily consolidate data from different data sources (Microsoft® SQL Server®, Microsoft® Access®, Sybase, Oracle, MYSQL, Firebird etc.).  Use the add-in to quickly import data and then use Excel's power to analyse it in more detail if needed.   To connect to a database once you have set up a connection profile you can quickly connect to database by selecting the database profile name from the dropdown box and hit the "SQL" Button. When you hit the "SQL" button with a database selected in the dropdown the main SQL Drill form will load and you will see the databases selectable objects (the tables and views) on the right hand side of the form.

- The core functionality of the add-in is the retrieval of the data into Excel and the "SQL" button on the toolbar loads the main form.  This form has been setup to make it easy to switch between different databases (and providers) and you can switch connection/provider by clicking the combobox towards the top left of the form and selecting an entry (this will disconnect the current connection automatically). To get the data from a database into Excel you execute a query or select statement on the form.   SQL Drill supports two way query building so you can build the query manually by typing it in to the text box or do it the easy way by dragging the relevant objects (tables or views) across in the objects area of the form. Then you can click the different options you want in the form and build the query visually in a very similar way than you would do in Microsoft Access or Microsoft SQL Server.

- You can download SQL Drill by clicking the button below. Please note that you will download the ZIP File (sql_drill_setup.zip) which contains the MSI installation package.

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.