Business    Databases & Tools     SQL Drill

SQL Drill 1.4


Description of

SQL Drill


SQL Drill is a freeware Microsoft Excel based add-in that runs in Excel 2000, 2002(XP), 2003 and 2007 (Excel for windows).- SQL Drill is a Genuine Freeware so no tricks - no Ads, no Spyware, no Viruses no Time limits etc... The primary download for the Add-in is from Download.com and they verify the contents of the file for of anything malware related. The add-in has also been verified by numerous other freeware sitesThe points below gives you a brief overview of the SQL Drill Excel Add-in. Easy to import data to Excel from SQL Server, MYSQL, Oracle, Sybase, Microsoft Access, FireBird, DB2, Excel Workbooks etc. SQL Drill works with any ODBC compatible data source. Use the add-in to quickly import data and then use Excels power to analyse it in more detail if needed.Data retrieval is fast (very good speed performance..).Genuine Freeware! No Ads, No Spyware, No Viruses No Time limits, No Phone Home...Add-in user interface is implemented via a small toolbar which will be added to your excel. The toolbar wont take up too much space in Excel and you can move it to where you want it. A new feature in this release is the Connection Profile Combobox. So it is possible to select a connection directly from the toolbar and hit the [SQL] button and you will connect to the database and view the available selectable objects in the main SQL Drill Form. If you hit the [SQL] button with the default entry [SQL Drill Toolbar] you will load the main Form without any connection being opened (use this when you want to set up some new or manage existing connection profiles). Easy to build complex queries using the visual interface. SQL Drill implements two way query building so you can (i) build queries visually by dragging/clicking and (ii) build queries by manually typing in the SELECT statement. The main form of the add-in incorporates alot of functionality but is still easy-to-use. - 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. 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. Related point is that even though I hope you wont uninstall it !) uninstalling it is easy (just do it from the Control Panel and then go and delete the SQL Drill Add-in folder). The add-in installation does NOT install any ADO libraries/MDAC or the MSXML parser (you need to have these already). As they are installation prerequisites and not included in the package install.- 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. - 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. The main form has some options to set: where the data will get pasted within Excel (active cell, new worksheet or "select cell"), whether or not the pasted data will have formatting applied and also to set whether or not Fields headings will be pasted and if so whether there will be automatic filters applied or not.- SQLDrill.dll (the core file of the Add-in) has a small size (400k), and wont slow your Excel down


Published by: sqldrill.com
Downloads: 648
File Size: 3.0 MB
License: Freeware
Product Homepage: Visit sqldrill.com
Release Date: 15 November, 2012
OS: Windows
Download Location: Primary Download Link Broken? Report it!


SQL Drill 1.4 Download Tags:


Files32.com collects software information directly from original developers using software submission form. Sometimes it can happen that software data are not complete or are outdated. You should confirm all information before relying on it. Using crack, serial number, registration code, keygen and other warez or nulled soft is illegal (even downloading from torrent network) and could be considered as theft in your area. Files32 does not provide download link from Rapidshare, Yousendit, Mediafire, Filefactory and other Free file hosting service also. The software has been submitted by its publisher directly, not obtained from any Peer to Peer file sharing applications such as Shareaza, Limewire, Kazaa, Imesh, BearShare, Overnet, Morpheus, eDonkey, eMule, Ares, BitTorrent Azureus etc..
SQL Drill Related Software

Apex SQL Report by Apex SQL Tools

Apex SQL Report 2005.02
Apex SQL Tools has released new version of Apex SQL Report. Apex SQL Report is a web solution crafted for SQL developers. Apex SQL Report is a SQL tool that generates HTML and graphical reports....

License:  Shareware
Platform:  Windows
File Size: 3.8 MB
Cost: $599.00

 

Godsw SQL Compare by Godsw,Inc.

Godsw SQL Compare 2.6.1
What is Godsw SQL Compare? Godsw SQL Compare is the powerful database schema/data compare and merge tool for Microsoft SQL Server.

License:  Shareware
Platform:  Windows
File Size: 4.8 MB
Cost: $199.00

 

dbExpress driver for SQL Server by Devart

dbExpress driver for SQL Server 6.6
dbExpress is database-independent layer that defines common interface for fast access and high performance database connectivity to MS SQL Server databases from Delphi. It works using high...

License:  Shareware
Platform:  Linux
File Size: 2.4 MB
Cost: $149.95

 

Apex SQL Log by Apex SQL Tools

Apex SQL Log 2005.10
Apex SQL Log is a powerful SQL database auditing and recovery tool that analyzes SQL Server's own Transaction Log to display information on data and structural changes. Since Apex SQL Log reads the...

License:  Shareware
Platform:  Windows
File Size: 12.1 MB
Cost: $999.00

 

Apex SQL Script by Apex SQL Tools

Apex SQL Script 2005.10
Apex SQL Script converts databases to scripts, .net exe's and deployment packages. Apex SQL Script creates insert scripts from any Microsoft SQL Server database that can be archived, emailed,...

License:  Shareware
Platform:  Windows
File Size: 12.5 MB
Cost: $299.00

 

Apex SQL Audit by Apex SQL Tools

Apex SQL Audit 2005.07
Apex SQL Audit proves a comprehensive, enterprise level active data auditing tool for Microsoft SQL Server Database auditing. This Apex SQL Auditing tool is both configurable and scriptable and...

License:  Shareware
Platform:  Windows
File Size: 11.9 MB
Cost: $599.00

 

DbaMgr2k 0.21.1
DbaMgr provides a graphical management interface for MS MSDE 2000 installations.

License:  Freeware
Platform: 
File Size: 3.7 MB

 

DbSchema 6.1
DbSchema is a database tool for managing database data and schema, it brings both database schema and data in a single unified workflow.

License:  Shareware
Platform: 
File Size: 106.1 MB

 
 
Top Software

FTP Rush 2.1.8
FTP Rush is a free comprehensive FTP client for smooth file transfer. The program offers fully-fledged functionality delivered in a user-friendly interface and allows experienced users to create...

Crypt4Free by

Crypt4Free 5.47
Crypt4Free is files encryption software with ability to encrypt files and text messages. Support for ZIP files and ability to secure delete sensitive files. Skinnable user friendly interface.

Luxand Blink! by

Luxand Blink! 2.0
Login to your PC without touching a thing! Luxand Blink! is a free tool to let you log in to your Windows account by simply looking into a webcam - no passwords to type and no fingers to scan.

InTask Personal by

InTask Personal 1.5
InTask designed to help team leaders, developers and QA persons to share their efforts and deliver the products on time. The product includes fast task management, interactive gantt, document...

Pop-up Free by

Pop-up Free 1.56
Get rid of annoying popup windows and enhance your Web surf experience. Kill unexpected popup windows and protect your privacy. No more annoying advertisement windows and save your time.

Glary Utilities Portable by

Glary Utilities Portable 2.56.0.8322
One Click A Day For PC Maintenance, Keeps Any PC Problems Away. With 7 million worldwide users, the first-rank & free Glary Utilities is an INDISPENSABLE friend for your PC, with its 100% safe,...

VPSpro by

VPSpro 3.695
VPSpro is the ultimate in the creation of financial projection and general business plans. The unique walk-through process is simple to use and makes easy work of the hard parts of business planning.

Rylstim Budget Lite by

Rylstim Budget Lite 4.5.1.6376
Plan and manage your finances with a simple friendly calendar. Perfect solution for home users and freelancers!

Neox Screen by

Neox Screen 1.0.0.277
Neox Screen is a free application which with the help of the hotkeys you can take screenshots that are crystal sharp, small in size and ready to be shared.

EMCO Remote Installer Free by

EMCO Remote Installer Free 4.1.1
This free remote software deployment tool is designed to install and uninstall Windows software on remote PCs through local networks. You can use it to install and uninstall EXE setups and MSI...

Latest Software

SAM Broadcaster Cloud by

SAM Broadcaster Cloud 2018.10.0
Start your own radio station with SAM Broadcaster Cloud - Powerful cloud Internet Radio broadcasting Solution. Automation scheduling, multi DJ, multi station, automatic failover, no setup streaming...

CRD Crystal Reports Scheduler 7.8.20190109
CRD is a Crystal Reports Scheduler that saves time and money by making it easy to schedule & automate Crystal Reports to print, fax, folder, FTP, SMS, DropBox, Sharepoint & email.

Elcomsoft eXplorer for WhatsApp 2.60.29966
Download, view and decrypt WhatsApp histories from Android and iOS devices. The tool automatically acquires WhatsApp data from a range of local and cloud sources, processes information and displays...

Start Menu 8 by

Start Menu 8 4.6.0.1
Start Menu 8 is a desktop customized utility for Windows users, specifically designed to bring back the familiar Classic Start Menu to Windows 8/8.1 & Windows 10.

CAD DLL 14
The library integrates CAD into applications in VC++, C#, Delphi, etc. without AutoCAD installation. CAD DLL license is royalty-free and has no time limitations. Supported formats: DWG/DXF, DWF,...

LINEAR ALGEBRA UNLEASHED by

LINEAR ALGEBRA UNLEASHED 2.1a
Linear Algebra Unleashed 2.1a is a matrix calculator that solves for and displays the solutions to almost all operations with regards matrix algebra or linear algebra. Linear Algebra Unleashed...

The Reverse Experience by

The Reverse Experience 2019.02.15
The Reverse Experience is a very special Reversi / Othello player. It includes a powerful game-search based optimization engine that allows to customize the game's various play strategies.

JPG Rename Multiple Files Based On Date Taken Software by

JPG Rename Multiple Files Based On Date Taken Software 7.0
This software offers a solution to users who want to change the filenames of one or more JPG files. The user simply chooses a list of files or an entire folder to process.

Easter Dinner Checklist by

Easter Dinner Checklist 1.07
Holding an Easter dinner can be a huge undertaking if you plan to invite guests and celebrate this holiday in the best way. Easter Dinner Checklist is designed to help families pull off the dinner...

NTP Time Zone Clock by

NTP Time Zone Clock 1.0
This downloadable NTP time zone clock displays the local time of over 300 cities around the world.

UkeySoft File Lock 11.2.0
UkeySoft File Lock is a useful data security tool to hide or lock files and folders on internal hard drive, USB flash drive, external drive, memory card and network drive. Password protect folders,...

UFO VPN 2.1.0
UFO VPN, the best free, fast and unlimited VPN proxy for Android devices! Your first choice to use secure WiFi hotspots, protect your privacy and access all websites. It is the most easy-to-use VPN...

Related Searches

Currently Searching

Currently Downloading

ExcelTrans by

ExcelTrans 5.0
ExcelTrans is an excellent internet translator. It can be used for your daily translation, such as email translation, Website translation, Microsoft Office document translation especially Excel...

SH Archive Identifier v2.60
SH Archive Identifier is a command-line utility which allows you to identify numerous archive and self-extracting files.

Diet Spread by

Diet Spread 4.0
Diet Spread is a lightweight spreadsheet/database. The database accepts nutritional values from your food labels. The spreadsheet displays, summarizes, and prints the nutrient values using...

Pixel Repair by

Pixel Repair 0.6.8.688
With this little tool, you can detect and fix stuck pixels on flat LCD screens. It won't bring completely dead (i.e. black) pixels back to life, but it should work if they're just stuck on a...

Project Magician v2.0.0
Allows you to ensure that you're including all the files you need to install your Windows application.

NT Registry Tweaker for U3 flash drives by

NT Registry Tweaker for U3 flash drives 1.0
NT Registry Tweaker - free registry tool to manage your Windows. Speed up your system and Internet, tune Explorer, apply security policy.

ern+Ahrungsmanager Ern+Ahrungssoftware by

ern+Ahrungsmanager Ern+Ahrungssoftware 3.5.0
Ein echtes Ern+Ahrungstagebuch mit einfacher Bedienung auch f+-r weniger ge+-bte Computerbenutzer bietet der ern+Ahrungsmanager 2010.

Le Mort D'Arthur v1.0
Le Mort D'Arthur is a desktop theme featuring the painting "Le Mort D'Arthur&quot\; by James Archer. It includes wallpaper, icons, cursors, animated cursors, and WAV sounds.

Memorize digits 0 by

Memorize digits 0 1
Memorize the nombers. You can do it! Memory is one of the activities of the human mind. It is the capacity to retain an impression of past experiences.

Easy File Management Web Server by

Easy File Management Web Server 5.0
Easy File Management Web Server is a web based file management software to manage your files and folders easily through a web browser (Internet Explorer, FireFox, Safari etc).

Project Kaiser 7.2.1905
Project Kaiser is a web-based issue tracking and project management software, free for 5 users. Project Kaiser is not only issue tracker, but also a strong set of instruments for working with...

PCL to TIFF sdk unlimited license by

PCL to TIFF sdk unlimited license 2.1
OakDoc PCL to Tiff Converter is a powerful utility for creating or manipulating tiff files, it does not need the third part software support, quickly convert PCL4, PCL5e, PCL5c, PCL XL (PCL6) print...