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).

Autor er@essbase.ru

DONATE and make you wish

Future 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)

 

Last edited Jan 24, 2016 at 5:40 PM by er77, version 12