About Qweas     RSS Feeds     BBS Forum Make Qweas.com My Home Page     Bookmark this page Register     Login     Help     Send Feedback  
Windows   Mac   Linux   Mobile   Games   Screensavers
Audio/Video Business Communication Desktop Develop Education Games Graphic Home Network Security Servers System Web
Accounting & Finance , Calculators & Converters , Databases & Tools , Helpdesk & Remote PC , Inventory & Barcoding , Investment Tools , Math & Scientific Tools , Office Suites & Tools , Other , PIMS & Calendars , Project Management , Vertical Market Apps
ImTOO iPod Computer Transfer for Mac

CD to MP3 Ripper


CAPM- Exam simulation software

ABC Amber Paradox Converter

Ultra QuickTime Converter

Crystal Cave Gold

Liong: The Dragon Dance

Edraw Flowchart Software

MP3 & MPEG Joiner

Power CD to MP3 Maker

Modem Spy

Related Reviews - more
database management

database monitoring

backup database

database administrator

database development

database connect

database applications

database designer

database optimization

database access tools

invoice software

invoice creator

personal finance software

business finace software

finance management

accounting management

financial analysis

check tools

rate calculators

liquidity calculators

mortgage calculators

payment calculator

interest calculator

budget calculators
Home > Business > Databases & Tools > SQL Drill

Detailed Description of SQL Drill 1.4

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

SQL Drill is designed for:
Win2000,WinXP,WinServer,WinVista,WinVista x64

SQL Drill has the following requirements :

Windows, Excel, MSXML Parser, MDAC


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

Site Map | Sort by Letters | Submit Software | Popular Downloads | Editor Picks | New Releases : Mac , Freeware | Updates : Mac , Freeware
Copyright © 2005-2012 Qweas Inc. All rights reserved. Get Buttons - Link to Us - About Qweas - Contact Us - Terms of Service - Copyright Policy - Guidelines - Privacy Policy