SQL Excel Freeware (Joomla database link)

Serving 4259 extensions to the community

Home

SQL Excel is an Excel Add-in that can run in Excel 2000, 2002(XP), 2003 and 2007 (Excel for windows..) 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. It has a very easy to use interface. Very easy to check for example new forum posts or just take a look at your table data. SQL Excel 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. SQL Excel adds easy database access to MS Excel. SQL Excel 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 (this is deliberate). 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 Excel 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, Uninstalling the add-in is a simple precedure. The add-in just references them though through late binding. SQL Excel can connect to all standard databases so you can easily consolidate data from different data sources (MS SQL Server, MS Acces, 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. For more information, please look at http://www.sqlexcel.net

Reviews (4)

good excel addin

byliverpoolFC on October 3, 2008

Very good excel addin. Dead handy way to take check table data.
good weekend everyone !!
chris

very useful tool

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

Helpful tool

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.

What a contribution !!

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.

Categories

SQL Excel Freeware (Joomla database link)