Help files

Execute SQL Statement Action

Description:

This Action connects to a database and executes a SQL statement

executesql.png

Properties:

Connection String:

Enter how to connect with the database. The button on the right (with ellipses) will allow you to build the connection string.

SQL Statement:

Enter the SQL Statement to be issued to the database here

Timeout:

The Execute SQL Statement Action waits for a result from the database. Choose a maximum amount of time that the action will wait.

Store Query Result into:

Enter a name to be the Variable that will store the result from the database in the form of a data table, with rows and columns.

More about connecting to a database and executing SQL Queries on it, please visit:

Connecting to a Database

Connect to Excel or Access Database

Connection Strings and Drivers