Search Results for "sql excel"

SQL Notebook is a free Windows application for querying and analyzing data across multiple sources, including SQLite, PostgreSQL, Excel, and CSV files. It combines a SQL editor with a notebook interface, allowing for data exploration, transformation, and visualization in one place. SQL Notebook is ideal for analysts and data enthusiasts.

SQL Explorer aims to make the flow of data between people fast, simple, and confusion-free. It is a Django-based application that you can add to an existing Django site, or use as a standalone business intelligence tool. Quickly write and share SQL queries in a simple, usable SQL editor, preview the results in the browser, share links, download CSV, JSON, or Excel files (and even expose queries as API endpoints, if desired), and keep the information flowing! ...

DBeaver is a free, multi-platform database tool that supports any database having a JDBC driver. It is useful for developers, SQL programmers, database administrators and analysts. DBeaver comes with plenty of great features such as metadata and SQL editors, ERD, data export/import/migration and more. Plugins are available for certain databases, and there are also several database management utilities. DBeaver’s Enterprise Edition provides even more features and supports non-JDBC datasources.

1.SQL Compare Compare and synchronize SQL Server database schemas effortlessly. 2.SQL Data Compare Identify and sync data differences between SQL Server databases. 3.Folder to SQL Compare Compare SQL script folders with live SQL Server databases. 4.SQL Trace / SQL Profiler (Azure Supported) Capture, trace, and analyze SQL Server events and performance — includes Azure SQL support. 5.SQL Table Documents Generate structured documentation for SQL Server table schemas. 6.SQL Data Export Export SQL Server data into multiple formats (CSV, Excel, JSON, etc.). 7.Excel to SQL Move Import Excel spreadsheets directly into SQL Server tables. 8.Import / Export Data Perform high-speed bulk data transfer between databases and formats. 9.Daily Tasks Automate and schedule routine SQL Server maintenance tasks. 10.Procedure Creation Easily design, edit, and manage stored procedures. 11.Script Maintenance Organize, version, and manage SQL scripts within the applica

...Queries support safe parameterization, SQL files, transactions, and bulk operations. Result collections can be converted into dictionaries or exported through Tablib to formats such as CSV, JSON, Excel, HTML, YAML, and Pandas DataFrames. A command-line utility allows SQL queries and exports to be performed outside Python code. The library focuses on keeping raw SQL workflows concise and readable.

'MySQL2Excel_Exporter' is an desktop application developed using python 3.6.8 and other add-on libaries. The application exports MySql tables as a excel file. MySQL2Excel_Exporter has two parts: 1) Export - converts all records in mySQL table into excel file 2) Export Filter - converts selected recorerds in mySQL table into excel file Compatible only for windows OS.

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"

DBGet is a light-weight database Schema Browser and SQL Editor for Sybase, Oracle, SQL Server & IBM DB2 databases.

DaFT is a frontend to any database that can be connected via ODBC. It provides list views of tables and columns, table view of data, SQL editor, CSV,HTML,SyLK,XLS data format export, and functions for copying data between two ODBC databases.

NEW version 1.0.6!!! is released. Bugs fixed related to system thread. Database Management Control for FireBird database developed using .NET (C#) .