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
Get Avast Free Antivirus with 24/7 AI-powered online scam detection Icon
Get Avast Free Antivirus with 24/7 AI-powered online scam detection

Get protection for today’s online threats. Free.

Award-winning antivirus protection, as well as protection against online scams, dangerous Wi-Fi connections, hacked accounts, and ransomware. It includes Avast Assistant, your built-in AI partner, which gives you help with suspicious online messages, offers, and more.
Free Download
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

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

Related Categories

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

Registered

2020-06-14