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"
XLS/Loader is an easy to use, Java based GUI application that brings your Excel worksheets, when structured as simple table, fast and easily in your RDBMS (supports Oracle, MySQL, PostgreSQL). Requires at least JRE5.
Java GUI application for loading a plain Excel Worksheet as new table into an ORACLE database - simple but sophisticated and very fast. {xls oracle load loader excel} - SUPERSEDED BY XLS/Loader => http://xlsloader.sourceforge.net/
ErgoTabcalc is a general calculation and report system. Calculation sequences are stored in the database. These sequences are made from simple operations on data, eg, add two table columns, or sort a table. This is similar to relational algebra.
Deploy in 115+ regions with the modern database for every enterprise.
MongoDB Atlas gives you the freedom to build and run modern applications anywhere—across AWS, Azure, and Google Cloud. With global availability in over 115 regions, Atlas lets you deploy close to your users, meet compliance needs, and scale with confidence across any geography.
QExcel Converter SQL QT4, Import xml excel/openoffice 2003 format, sqlite3 sql text/binary, edit table and export to various Format, Pdf XSL format objects Apache fop JAVA(XSL-FO), XML/XSLT , excel, SQL text sqlite3 dump file and MYSQL SQL to XML/XSL.
Framework for development of MS Excel add-ins that allow user defined functions that return more than a single value (e.g. to return table data with a single function call)