Other freebies...
XLSQLite.xlam
This Excel add-in was developed as a 'side' project while developing Gatekeeper. It uses SQLite for Excel to interact with SQLite databases and provides a simple GUI that facilitates the creation and manipulation of SQLite databases directly from within Excel.
It also provides functionality to execute SELECT statements directly from within an Excel array formula and return the result in a range of cells. The workbook SQLite_Demo.xlsm (also included in the download file 'XLSQLite.zip' found below) gives a quick demo of this functionality (does not require the add-in to be installed).
Enjoy!
This Excel add-in was developed as a 'side' project while developing Gatekeeper. It uses SQLite for Excel to interact with SQLite databases and provides a simple GUI that facilitates the creation and manipulation of SQLite databases directly from within Excel.
It also provides functionality to execute SELECT statements directly from within an Excel array formula and return the result in a range of cells. The workbook SQLite_Demo.xlsm (also included in the download file 'XLSQLite.zip' found below) gives a quick demo of this functionality (does not require the add-in to be installed).
Enjoy!

xlsqlite.zip | |
File Size: | 890 kb |
File Type: | zip |
MD5: BDE724F7397CA1D7BA0CECDEE5929F49
Last updated: 01 August 2014
Last updated: 01 August 2014