Excel Execute Sql Script

Connect Window is a handy application if you need to export the results from a database query. The program allows you to save them to an Excel file for later use. There are two methods to connect: with predefined data source or using direct connection to server or database file. In the first...

Using SQLScriptGenerator you can connect to your local or remove SQL Server and generate T-SQL script of the whole database or just database structure or just data or specific database objects. In the result it generates one or several *.sql files with CREATE, INSERT T-SQL statements that...

OleDBCmd allows you to execute SQL commands against an OleDB Database, eg a Microsoft Access database, an Excel spreadsheet, etc. This can be a powerful adjunct to LGX Report (see www.freereporting.com) as it allows database creation to be scripted rather than manually creating a database with...


Platforms: Windows

This Export tool for Microsoft SQL server will create SQL script for database objects definitions: tables, views, triggers, indexes, primary and foreign keys, procedures, etc. The tool supports ANSI and UNICODE scripts. Also, custom or predefined SQL statements separators are supported. The...


Platforms: Windows, 2003, Windows Vista, 2008, 7

Foxy SQL Free is a database script and query tool designed for DB professionals. It allows you to execute SQL commands and queries against any database. Supported DB: Oracle, MS SQL, IB, DB2, MySQL, PostgreSQL, Firebird, Sybase ASE and more. Key features: access to a lot of different databases,...


Platforms: Windows, Mac

FlowHeater is a powerful tool for connecting widely differing data sources and targets using a flexible graphically defined conversion. CSV (text) import/export becomes childs play. Adapters are available for import/export/update of MS Access, MS Excel, MS SQL Server, MySQL, SQLite, PostgreSQL,...


Platforms: Windows, Windows 8, Windows 7, Windows Server

DBConvert for Excel & MS SQL is a strong utility that allows you to convert their Excel and MySQL databases. The user can convert data from: MS Excel to MS SQL, MS Excel to MS SQL Dump, MS Excel to MS Excel, MS SQL to MS Excel, MS SQL to MS SQL and MS SQL to MS SQL Dump. You can convert your...


Platforms: Windows, 2K, XP, 2003, Windows Vista, 7, 7x64

QT SQL Monitor is a simple, easy to use GUI application specially designed to help you with the administration of SQL servers. The currently supported servers are PostgreSQL, MySQL, Sqlite and FireBird.


Platforms: Windows

RISE SQL Server code generator The RISE SQL Server code generator generates a native Transact SQL script. The script incrementally updates the tables, columns, indexes and constraints in the database to match the RISE model. Once the database is updated, the views defined in the RISE model are...


Platforms: Windows

SQL Editor is the tool that allows you to execute SQL queries and scripts development quickly and simply. This software will prove to be a smart choice for anyone who wants to edit SQL scripts and requires an easy-to-use interface. Features : Support for Microsoft® SQL Server™ 2008...


Platforms: Windows

EasySQL classes provides the same interface to compose and execute SQL queries to access several types of SQL databases: MySQL, PostgreSQL and SQLite.The script provides simple methods that will help to compose and execute SQL queries of the types: SELECT, INSERT, UPDATE, DELETE and...


Platforms: PHP

Get available SQL Servers Get/Set default data or log file locations Get server version and attributes Get database file sizes Get query results using a T-SQL script in a file Get available SQL Servers Get/Set default data or log file locations Get available SQL Servers Get/Set default data or...


Platforms: Windows, Windows 8, Windows 7

SQL Studio Query eXecutor (QX) is a simple query and SQL script execution utility for Microsoft SQL Server. It features color syntax highlighting, whole script or selected statements execution, executing of SQL scripts or stored procedures, and multiple result tables. Convenient functions to save...


Platforms: Windows

Define your database structure and relations once using the ZsqlML (Zenark's SQL Markup Language) XML DTD, and then generate mulitple vendor-specific SQL scripts, thereby solving the issue of SQL script variances across multiple platforms.


Platforms: Windows, Mac, Linux

The SQLite library includes a small command-line utility SQLite3 that will allow you to manually enter and execute SQL commands against an SQLite3 database. This document provides a brief introduction on how to use sqlite3. To start the SQLite3 program, just type "sqlite3" followed by the name...


Platforms: Windows

True MySQL class can connect to a specified MySQL host, execute SQL queries and retrieve the results into arrays or objects.Key Features of True MySQL class:- Seek SQL query result sets- Get the number of affected rows and the identifier of the last record inserted by a query- Retrieve the names...


Platforms: PHP

DBClass can establish connections to a given MySQL database server and execute SQL queries.The results for a SELECT query can be returned in an array.


Platforms: PHP

MySQL DB Management Class can access a MySQL database and execute SQL queries retrieving the results into arrays in a single call.MySQL DB Management Class can also show links to browse the query results split among multiple pages.INSERT and UPDATE can be executed from lists of parameters.


Platforms: PHP

GafDb can connect to a database and execute SQL queries.In debug mode GafDb can display messages of progress of each operation it executes. The progress and error messages are in Portuguese by default, but can changed to a different idiom.


Platforms: PHP

Oh!DB Table Data Gateway can perform the following operations:- Execute SQL SELECT queries from list of fields of a table- Retrieve the highest or the lowest value from an integer primary key table field- Get or delete one record of a table with a given primary key value- Delete all records of a...


Platforms: PHP