Introduced SQLite database connection

Version: 2021b

Type: Features

Category: Data Handling

Subcategory: Import

Jira: ORG-23537,ORG-23555

  1. Data: Connect to Database… menu to connect to a SQLite database file. SQLite ODBC driver will be list in the ODBC Driver list.

  2. File: Export: SQLite to export worksheet to SQLite database file. If export to an existing SQLite file, worksheet will be pushed in as a new table.

  3. Update Database context menu. When connect to SQLite database and query string is simple like “Select * from table“, then click the Database Connector icon, the “Update Database” context menu will be available, and user can update current worksheet data to the SQLite database file.