Main > Business & Finance > Spreadsheets >

SQL Drill Excel Freeware 1.4



 

SQL Drill Excel Freeware 1.4

Sponsored Links

SQL Drill Excel Freeware 1.4 Ranking & Summary

RankingClick at the star to rank
Ranking Level
User Review: 0 (0 times)
File size: 3.1MB
Platform: Windows 2003, Windows Vista, Windows Server 2
License: Freeware
Price:
Downloads: 35
Date added: 2009-05-09
Publisher: SQl Excel

SQL Drill Excel Freeware 1.4 description

SQL Drill Excel Freeware 1.4 offers you a powerful SQL Drill add-in: Simplify data retrieval from SQL Server, Oracle, Sybase, My SQL, DB2 and any other ODBC compliant database. SQL Drill adds easy database access to Microsoft Excel. Works with any ODBC compatible data source.

Major Features:

  1. SQL Drill is a freeware Microsoft® Excel® based add-in that can run in Excel 2000, 2002(XP), 2003 and 2007 (Excel for windows).
  2. SQL Drill is a Genuine Freeware so no tricks no Ads, no Spyware, no Viruses no Time limits, no "Phone Home"... 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 sites (see here).
  3. 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 within a database. 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. 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.
  4. 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.
  5. 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.
  6. Example of how the data is imported in excel.  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 headlings will be pasted and if so whether there will be automatic filters applied or not.
  7. SQLDrill.dll (the core file of the Add-in) has a small size (400k), and wont slow your Excel down

Enhancements:

  • Version 1.4 includes some minor bug fixes and also the addition of a new options form (where you can store certain settings).

Requirements: Microsoft Windows, Microsoft Excel, MSXML Parser, MDAC

WareSeeker Editor

SQL Drill Excel Freeware 1.4 Screenshot

SQL Drill Excel Freeware 1.4 Keywords

Bookmark SQL Drill Excel Freeware 1.4

Hyperlink code:
Link for forum:

SQL Drill Excel Freeware 1.4 Copyright

WareSeeker.com do not provide cracks, serial numbers etc for SQL Drill Excel Freeware 1.4. Any sharing links from rapidshare.com, yousendit.com or megaupload.com are also prohibited.

Allok Video Splitter 2.2.0 Review:

Name (Required)
Email(Required)
Captcha
Featured Software

Want to place your software product here?
Please contact us for consideration.

Contact WareSeeker.com
Related Software
SQL Drill Freeware Excel Add-In: simplify data retrieval from ODBC databases Free Download
SQL Excel Freeware Excel Add-In : Simplify data retrieval from SQL Server, Oracle, Sybase, MY SQL and any other ODBC compliant database. SQL Excel adds easy database access to MS Excel. Works with any ODBC compatible data source. Genuine Freeware! NO Ads, NO Spyware, NO Viruses NO Time limits. For more information, please look at http://www.sqlexcel.net Free Download
EMS SQL Manager Lite for SQL Server is a light and easy-to-use freeware graphical tool for MS SQL/MSDE administration. It has minimal required set of instruments for those users who are new to MS SQL server and need only its basic functionality. Free Download
Powerful database schema/data comparison and synchronization tool for SQL Server Free Download
compare & synchronize SQL Server database content Free Download
SQL Delta quickly compares and synchronizes SQL database structures and data. Free Download
Easy SQL Scripter scripts the database data and schema. You can select the schema tables and objects to include in the script Free Download
SQL Database Restore Tool to extract sql data from corrupt SQL databases, to recover SQL databases. SQL Database Recovery at SysTools Software repair and recover data from the corrupt MDF database of Microsoft SQL Server 2000. Free Download