SQL Excel - Freeware Excel Add-In - simplify data retrieval from SQL Server, Oracle, Sybase, MySQL, DB2, Microsoft Access etc| Download |
|
|
| Sunday, 27 April 2008 | |
|
If you have Windows 2000 and Later and Microsoft Excel 2000 or later, you should be able to install the Add-in easily. You will need to run the installation package to install the add-in so if you don't have an admin account you will need to ask an admin to install it for you. The add-in does use some components though that are present on standard windows builds and they are noted below. Before downloading, please make sure you can comply with the installation prequisites. Note on Installation Prequisites, the Installation Package does not install the Microsoft Data Access Component (MDAC) or the Microsoft XML Parser (MXSML) - both of these are necessary for the add-in to function. This is deliberate as the installation package has been kept simple. It is important too as this way if you want to Uninstall - you dont need to worry about it and can just use the control panel to remove the add-in. If these components had partially been included Uninstalling would have been a little bit messier.. In any care, most relatively recent builds (XP or later) will have these components on them already but you need to check this first.
Installation Prequisites:
Installation Instructions (1) If you have a previous version of SQL Excel - you need to uninstall this first (uninstall by going to Add/Remove programs section in the control panel). (2) Close out of all of instances of Microsoft Excel. (3) Download the SQL_Excel_Setup.zip file to a temporary folder on your machine. (4) Extract the contents to a temporary folder (you can delete this after the installation). (5) Run the SQLExcel.msi from your temporary folder location. (6) Re-open Excel and you should be all set (there will be no database connection configured and you will need to ad one in. To do this, hit the "SQL" button on the toolbar. When the form loads, you can then hit the "New/Edit" button to add in a connection profile.). (7) Optional but recommended - Excel Security Settings should be set up "Medium" level. On the Excel menu select TOOLS and then select OPTIONS and then go to the "Security" Tab and hit the "Macro Security" button. Then (i) On the "Security Level" tab - set to "Medium" and (ii) on the "Trusted Sources" tab" - "Trust all Installed Add-ins and Templates" and "Trust access to Visual Basic Projects " should both be checked. Setting Excel up like this will get rid of the "Macro Security" warnings when the add-in is loaded. If you install the add-in, Please help out by providing some feedback. All feedback is welcome.. I didnt include any tracking component or auto emailing in the add-in as I don't like it myself, but the downside to this is that I don't know how smooth things are going. You can use the "Contact Us" page to send back feedback if you don't want to register on the site. Registering just means you can post on the forum. Thanks, Al
|
|
| Last Updated ( Monday, 16 June 2008 ) |
SQL Excel Add-in |Copyright SQL Excel, 2007-2009 |Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation