Excel AddIn : In2Sql download

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

You can use in2Sql for creating connection for PowerQuery This tools do not exclude using each other

Project Activity

See All Activity >

License

BSD License

Follow Excel AddIn : In2Sql

Excel AddIn : In2Sql Web Site

Other Useful Business Software

MongoDB Atlas runs apps anywhere

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.

Start Free

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

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

Similar Business Software

WinSQL

WinSQL is a powerful universal database management tool that is used by 90 percent of Fortune 500 companies and more than a million programmers and DBAs around the globe. WinSQL is a generic querying tool that connects to any relational database (RDBMS) for which an Open Database Connectivity...

See Software
SSuite MonoBase Database

Create relational or flat file databases with unlimited tables, fields, and rows. Includes a custom report builder. Interface with ODBC compatible databases and create custom reports for them. Create your own personal and custom databases. Some Highlights: - Filter tables instantly -...

See Software
Row Zero

Row Zero is the best spreadsheet for big data. Row Zero matches the experience of traditional spreadsheets but can handle 1+ billion rows, process data much faster, and connect live to your data warehouse and other data sources. Row Zero spreadsheets are powerful enough to pull entire...

See Software
DbVisualizer

DbVisualizer is one of the world's most popular database editors. With almost 7 million downloads and Pro users in 150 countries worldwide, it won't disappoint you. Free and Pro versions are available. Developers, analysts, and DBAs use it to elevate their SQL experience with modern tools to...

See Software
Conversionomics

Set up all the automated connections you want, no per connection charges. Set up all the automated connections you want, no per-connection charges. Set up and scale your cloud data warehouse and processing operations – no tech expertise required. Improvise and ask the hard questions of your data...

See Software
RazorSQL

RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, macOS, Mac OS X, Linux, and Solaris. RazorSQL has been tested on over 40 databases, can connect to databases via either JDBC or ODBC. Browse database objects such as schemas, tables,...

See Software