Detailed Description of SQL Drill 1.4

SQL Drill is a Microsoft Excel based add-in that runs in Excel 2000, 2002 (XP), 2003 and 2007 (Excel for windows) and adds SQL functionality to Excel.

The core functionality of the add-in is the retrieveal 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 relevent 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 SQL Server.

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 addin. The combobox will hold your available connections and can be used to quickly connect to and view the available selectable objects. The additional toolbar is the only interface change you will have in Excel, so there is no Extra Menu for the add-in. Also there is no extra entry in your Program List for the add-in. So you will only have the extra toolbar.

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.).

TAGS OF SQL DRILL

sql server 7.0 design , mysql php , microsoft sql , sql navigator , sql server 7 0 design , word drill text drill , excel-mysql converter , sql 2000