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

Project Samples

Project Activity

See All Activity >

License

BSD License

Follow Excel AddIn : In2Sql

Excel AddIn : In2Sql Web Site

Other Useful Business Software
Gen AI apps are built with MongoDB Atlas Icon
Gen AI apps are built with MongoDB Atlas

The database for AI-powered applications.

MongoDB Atlas is the developer-friendly database used to build, scale, and run gen AI and LLM-powered apps—without needing a separate vector database. Atlas offers built-in vector search, global availability across 115+ regions, and flexible document modeling. Start building AI apps faster, all in one place.
Start Free
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of Excel AddIn : In2Sql!

Additional Project Details

Operating Systems

Windows

Languages

English

Intended Audience

Advanced End Users, Developers

User Interface

Win32 (MS Windows)

Programming Language

C#

Database Environment

Microsoft Access, Microsoft SQL Server, MySQL, ODBC, Oracle, PostgreSQL (pgsql), SQL-based

Related Categories

C# Data Warehousing Software, C# Spreadsheet Software, C# ETL Tool, C# SQL Clients

Registered

2020-06-14