Using SQL statements in Excel enables you to connect to an external data source, parse field or table contents and import data – all without having to input the data manually.

Use these functions in your SQL INSERT, SELECT and UPDATE statements to store and retrieve information in encrypted form.

Create SQLite records with SQL The SQLite CLI allows you to issue any valid SQL statements you like. To create SQLite database records, simply issue the appropriate SQL insert commands. Similarly, to ...

Execute an SQL insert query With the HSQL JDBC connection created, you can obtain JDBC statement objects which enable you to issue SQL commands against the database.