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: 635
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

DVDFab Player 5 by

DVDFab Player 5 5.0.2.2
DVDFab Player 5 can play back all the video formats you have, including the HEVC (H.265), UHD (Ultra High Definition) and 4K videos as well as DVD/Blu-ray ISO image files and folders. It should be...

Database Browser 5.3.2.8
This Easy to use tool allows user to connect to any database and browse or modify data ,run sql scripts, export and print data. Works directly with Oracle, MS SQL Server, Interbase, MySQL and...

FaxTalk FaxCenter Pro 9.0.0.1440
Easy to use send and receive fax software for Windows. FaxTalk FaxCenter Pro manages your incoming and outgoing faxes quickly, efficiently, and reliably. From a single application you can send,...

MinimizeToTrayTool by

MinimizeToTrayTool 3.3
MinimizeToTrayTool is a freeware open source utility that allows the user to minimize any application to the windows tray.

HelpSmith by

HelpSmith 7.4.0.1108
HelpSmith is a complete help authoring tool for CHM, Web Help, and Printed Manuals Creation. Dynamic Styles, NO HTML Coding principle combined with the tool's useful features make help authoring a...

PitchGridTest by

PitchGridTest 1.00
The Pitch Grid Test assesses your relative pitch sense with a relative pitch indicator, which shows your pitch-distance recognition ability in cents. Your answering speed is also measured: an...

SamP3P4 by

SamP3P4 10.8.1.1
The great lottery software SamP3P4 since 2003 and continued strong. SamP3P4 software works with all the Pick 3/4 lotteries and supports 120 lotteries from the USA and Canada.

ThunderSoft Screen Recorder Free Edition by

ThunderSoft Screen Recorder Free Edition 8.3.0
Free Screen Recorder is an easy to use screen recording software for windows. It captures screen video, audio and also microphone sound at the same time.

A VIP Simple To Do List by

A VIP Simple To Do List 2.9.59
VIP Simple To Do List is an easy tool for planning of your daily life. The program lets everyone who wants to stop wasting time and bring life in order quickly manage everyday tasks with help of...

Nsauditor Network Security Auditor by

Nsauditor Network Security Auditor 3.0.27
Nsauditor is an advanced network security scanner for auditing and monitoring network computers for possible vulnerabilities. The software checks network computers using all potential methods that...

GlassWire Data Usage Monitor 2.0.316r
Instantly see which apps are wasting your data, acting suspiciously, slowing your phones Internet speed, or causing you to go over your carrier data limits. GlassWire makes it easy to keep track of...

VShell Server for Windows 4.4.1
VShell SSH server is a secure alternative to Telnet and FTP on Windows, Mac, and UNIX providing strong encryption, robust authentication and data integrity. Fine-tune your environment with...

Related Searches

Currently Searching

Currently Downloading

VISCOM 3D Carousel SDK ActiveX by

VISCOM 3D Carousel SDK ActiveX 2.41
For Windows Developers who need to 3D Carousel user interface in c++ , c#, vb.net , vb, delphi, vfp, access.

Weld Symbols VisualWeld by

Weld Symbols VisualWeld 04
Effective tool for addingf weld symbols in AutoCAD The program for adding Weld Symbols in AutoCAD drawings. Advanced interface and options of this program will help you in your work.

Smart Pet Health Professional by

Smart Pet Health Professional 1.10
Smart Pet Health Professional keeps as much information about your animals as you wish. You can create an extensive pet profile, including a picture of the animal and owner information. You can...

Leap Free All to AVI MPEG4 WMV Converter by

Leap Free All to AVI MPEG4 WMV Converter 4.0
Leap Free All to AVI MPEG4 WMV MOV FLASH Converter is the best solution for free converting diverse videos to AVI MPEG4,MOV,SWF etc.

FreeMedForms for Mac OS X by

FreeMedForms for Mac OS X 0.8.0
FreeMedForms is free and open source software, available for all current platforms (Linux, Mac OS X, Windows and FreeBSD). It is powerful and fully configurable.

Recover Corrupt Documents by

Recover Corrupt Documents 9.61
Recover corrupt Documents, Recover Documents, Recover corrupt Unsaved Documents: Download documents recovery Software at RecoverCorrupt.com How to recover corrupt Deleted documents, recover corrupt...

Hex Minesweeper v1.1
Hex Minesweeper is a twist on the classic Minesweeper game. Instead of using a map of four-sided squares this game uses a map of six sided hexagons. The object of the game is to locate all the...

ToggleTRAYTOOLS v2.1
ToggleTRAYTOOLS gives you point and click access to your favorite applications by letting you access them from the Windows 95 System Tray.

Soft Body 2.0
Soft Body help you analyze the three dimensional Soft Bodies behavior. The drill is as easy as can be: you just select the object that interests you and start your simulation. Study the 3D Soft...

RTSP/RTMP/HTTP DirectShow Source Filter by

RTSP/RTMP/HTTP DirectShow Source Filter 4.6.10
The Datastead RTSP DirectShow Source Filter SDK captures RTSP, RTMP, RTP, HTTP, UDP, RTP, MMS, Shoutcast sources, decodes the audio and video streams, exposes the uncompressed audio and video...

AP Scanner 1.0
Graphically show all in-range AirPort stations. AP Scanner allows you to view all AirPort 1.3 access points graphically that are within range.

Potatoshare SD Card Data Recovery by

Potatoshare SD Card Data Recovery 3.0.0.0
The least money,the best software.Potatoshare SD Card Data Recovery is safe, reliable and effective data recovery software which is designed to recover lost data from SD card with great performance...