SQL Spider Excel Ribbon

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
  • Disscusions and bug report

    • Vladimir Gostev

      А исходники доступны?

      • Это VBА проект в Excel . Он не запаролен. Лицензия BSD – передает все права пользователю. Можете делать все что угодно – Копирайт можно менять.