SQLite for Excel

SQLite is one of the best solutions to get started to SQL, especially since it provides a quick way to create a database and manage it. Not only is it lighter than the standard SQL, but it is also easier to navigate making it suitable for less tech-savvy users.

SQLite for Excel is a tiny wrapper that enables developers to access SQLite libraries from VBA. In other words, the DLL included allows the calls from VBA to be passed to an SQLite server without parameter changes.

To get started, simply decompress the archive in the desired location on the computer and open the VBA editor along with the Distribution\SQLiteForExcel.xls file. The next step entails the analysis and running of the example test code in the demo module.

A noteworthy benefit of employing the wrapper is that developers now have a high-performance path to the API functions. The semantics of the library calls are preserved, whereas the access to the distributed SQLite3.dll can be done without recompilation.

The application comes with vast documentation, so users who are having a hard time getting around should not hesitate to check various information on the typical usage of core routines, convenience wrappers or binding parameters, just to name a few.