execsql Run a SQL script against a Microsoft Access database and capture output
Download

execsql Ranking & Summary

execsql Tags

SQL execute script execute script sql execution script execution

execsql Description

Run a SQL script against a Microsoft Access database and capture output execsql is a Python based tool and program that will help you to apply a SQL query script stored in a text file to an Access database. The output of the last SQL query in the script can be automatically saved in a CSV file or routed to - and then viewed in an - Excel worksheet. Here are some key features of "execsql": · Execute a complex query script that selects and summarizes data, and capture the output in a comma-separated-value (CSV) file. The CSV file can then be used as input to other software, including statistical, spreadsheet, and database applications. · Execute a query script that selects and summarizes data, and view the results directly in Excel. · Execute SQL Data Definition Language (DDL) and Data Manipulation Language (DML) commands, stored in a text file, to create database tables and alter data in the database. Using execsql and other tools such as batch files and the Windows task scheduler, these operations can be set up so that they occur automatically without the need for any interactive use of Access. · Execute "CREATE QUERY..." and "CREATE TEMPORARY QUERY..." DDL statements, which are not natively supported by Access. This feature allows you to maintain a standard set of queries, or task-specific queries, in a text file and easily add them to any Access database. Support for "CREATE TEMPORARY QUERY..." DDL is also important to allow non-trivial data summarization scripts.

execsql Related Software