Detailed Description of SQL Drill Freeware 1.4

SQL Drill is a Microsoft Excel add-in that makes it really easy to use the SQL language directly from Excel. SQL Drill is a cross database query tool that works with all standard database types.

SQL Drill runs in Excel 2000, 2002 (XP), 2003, 2007 and 2010 (Excel for Windows).

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 adds easy database access to 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 addin. The combobox will hold your available connections and can be used to quickly connect to and view the available selectable objects.

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 Excel form will load and you will see the databases selectable objects (the tables and views) on the right hand side of the form.

SQLDrill.dll (the core file of the Add-in) has a small size (400k), and wont slow your Excel down

TAGS OF SQL DRILL FREEWARE

freeware games , web cam freeware , freeware game , audio freeware , mahjong freeware , freeware tvr , freeware spades , freeware spiele , free freeware , racing freeware