Gatekeeper for Excel
If you have any feedback, or questions, please contact us
  • Gk Home
  • Gk Requirements
  • Screenshots
  • Downloads
    • Release log
  • FAQs
    • Troubleshooting
  • Referenced projects
    • Other freebies
  • Tip jar

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!



xlsqlite.zip
File Size: 890 kb
File Type: zip
Download File

MD5:  BDE724F7397CA1D7BA0CECDEE5929F49
Last updated: 01 August 2014













Powered by Create your own unique website with customizable templates.