Serving 3557 extensions to the community
Categories
Directory Menu
Login or Register
SQL Excel Freeware (Joomla database link) 
Version
1.4 (last update on Apr 11, 2009)
Rating
Compatibility
Votes
11
Favoured
29
License
Other
Non-Commercial
Type
Views
27482
Date Added
28 August 2008
It can be a great time saver for working with Joomla as it makes it very easy to retrieve data from your Joomla database directly in Excel. SQL Drill can also connect to any database that supports the ODBC standard (so you can connect to MYSQL, SQL Server, Oracle, Firebird, Sybase, Microsoft Access etc).
It has a very easy to use interface and supports graphical query building so it makes it fairly easy to construct complex queries. Very easy to check for example new forum posts or just take a look at your table data.
SQL Drill is a Genuine Freeware so no tricks. The primary download for the Add-in is from Download.com and they verify the contents of the file for of anything malware related.
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 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, uninstalling the add-in is a simple procedure. The add-in just references them though through late binding.
Use the add-in to quickly import data and then use Excel's power to analyse it in more detail if needed.
For more information, please look at http://www.sqldrill.com
Images
byVikas1971 on April 24, 2009
this "addin" attached itself to Microsoft Excel program and after I set up my connection using the mysql "connector" - I was able to see my joomla data in Microsoft Excel. Thank you
byliverpoolFC on October 3, 2008
Very good excel addin. Dead handy way to take check table data.
good weekend everyone !!
chris
good weekend everyone !!
chris
byJohnny_Trip on September 14, 2008
great tool. Installion process was easy and the tool bar appeared in Excel after it. It took some time to setup the connection to my database but once set it is very easy to import to excel. The interface for querying is awesome. Great job. Keep it up
byprofinvent on August 30, 2008
Downloaded the tool, then installed it and was managed to use it within few minutes. Detailed documentation is available on developer’s website, so it helps inexperienced users do download MySQL ODBC driver, install it and start using this tool.
Tool helps you to create a DB connection, then to query DB and build SQL queries by dragging the mouse. Great. Once the query is defined you can export the results straight to excel spreadsheet for detailed analysis.
I wish I saw more tools like that in the extensions repository.
Tool helps you to create a DB connection, then to query DB and build SQL queries by dragging the mouse. Great. Once the query is defined you can export the results straight to excel spreadsheet for detailed analysis.
I wish I saw more tools like that in the extensions repository.
byspark529 on August 29, 2008
One of the most useful programs ever developed ! That too at no cost. Really amazing. Hats off to you and all your team for such an excellent peace of Excel addin.