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
*auto-build query tool can create SQL select statement by using different database tables with matching them by column name
* creating connections for PowerQuery
news and updates
-- change list --
v05 beta
export tables and SQL to CSV files
treat CSV like relational tables
--
add Cloud ClickHouse Source
resolve the problem with an untrusted source
changed Sql Editor
fixed behavior for "update rows"
Features
- excel sql