Add-on Excel Ribbon “SQL Spider” allows you to save SQL statements to databases in a common format, so that it is available at one mouse click. In the free versions it have only simple actions – such as delete all entries similar to the selected (Remove Only), or vice versa leave only similar (Keep Only). Additionally it allows you to build a Pivot Table report on an external data source (SQL Query).
essbase.ru:SQLSpider.rar
upd: This version is free under BSD license
Installation:
1. extract the files in this zip file to your default add-in folder
typically (C:\Users\%USERNAME%\AppData\Roaming\Microsoft\AddIns)
2. Open Excel and register the add-in
a)Click the File tab, click Options, and then click the Add-Ins category.
b)In the Manage box, click Excel Add-ins, and then click Go. The Add-Ins dialog box appears.
c)Click Browse in the Add-Ins dialog box to locate the add-in, and then click OK.
Pre ORder for Enterprise versions for $10 per user annual
Enterprise feature list
Cross-Link SQL report between different SQL queries Update settings from one file store Input form for filing date to the SQL tables “Undo” Action Work with MsSQL, MySQL,PostgreSQL database (free version supports only Oracle) Support in the work time
