https://sourceforge.net/projects/in2sql
Video for best usage https://rb.gy/tvl8lk
This Excel Addin helps SQL analytic create an Excel report based on ODBC relational data.
*Creates table base on data from a relational database
*Generate a pivot report using the same external connection (1)
*Some ad-hoc tools are available - like "keep only" and "remove only"
*you can use the row limit option for exploring the largest dataset
*The ODBC connection manager is available...
We have develop data mining 'Plug and Play' WYSIWYG Tool on commercial ERP Baan IVc4 which uses Baan 4 GL as extract and transform engine and MS excel as load client . For more information about the tool and the company , please visit www.erpjewels.com