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

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.

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.