Skip to content

Latest commit

 

History

History
23 lines (15 loc) · 1.32 KB

README.md

File metadata and controls

23 lines (15 loc) · 1.32 KB
Raw

SqliteVba

VBA classes written for use in Excel to interact with SQLite

I am working with Windows colleagues and need to provide a database for storage and data management. I decided against MS Access and opted for SQLite for reasons that I will explain in the future. The plan is to use Excel as a front-end for end users with SQLite in the backend. This is a work in progress. The classes are not yet tested or documented.

Aim to write this up in a lengthy blog entry

  • Requires installation of SQLite exe (from the SQLite downloads page) and the Sqlite ODBC driver (http://www.ch-werner.de/sqliteodbc/).
  • In the VBA editor, add references to the ADO and scripting runtime libraries.

Links that I have used:

  1. Microsoft ADO API Reference: https://msdn.microsoft.com/en-us/library/ms807498.aspx
  2. Good tips on an object oriented approach - Class Module to wrap up classic ADO call to SQL-server: http://codereview.stackexchange.com/questions/116253/class-module-to-wrap-up-classic-ado-call-to-sql-server/116254
  3. Creating ADODB Parameters on the fly: http://codereview.stackexchange.com/questions/46312/creating-adodb-parameters-on-the-fly
  4. How to transfer data from an ADO Recordset to Excel with automation: https://support.microsoft.com/en-gb/kb/246335
  5. Good review of dictionaries: http://excelmacromastery.com/vba-dictionary/