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