SQLiteC-for-VBA
SQLiteForExcel
Our great sponsors
SQLiteC-for-VBA | SQLiteForExcel | |
---|---|---|
1 | 1 | |
4 | 242 | |
- | - | |
0.0 | 0.0 | |
over 2 years ago | over 1 year ago | |
VBA | C | |
MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
SQLiteC-for-VBA
-
[EXCEL] SQLite C/ADO VBA library with reflection
Complete project source code with dependencies is available from the GitHub repo and the project documentation - from the GitHub pages site. I perform unit testing under x32/VBA6 (Excel XP/2002 SP3) and x64/VBA7 (Excel 2016) environments. With the entire repository cloned on Windows 10 and the two dependencies (the SQLiteODBC driver and the RubberDuck VBA add-in) installed, the following two quick checks can be executed right away from the immediate pane. This command ?LiteMan(":mem:").ExecADO.GetScalar("SELECT sqlite_version()") returns SQLite library version used by the SQLiteODBC driver (usually embedded), e.g., 3.23.3, and this command ?SQLiteC("").CreateConnection(":mem:").ExecADO.GetScalar("SELECT sqlite_version()") returns SQLite library version loaded by the project, e.g., 3.37.0. The project also includes a set of examples, which should also run out-of-the-box (see documentation).
SQLiteForExcel
-
[EXCEL] SQLite C/ADO VBA library with reflection
The SQLiteCAdo library is a VBA middleware facilitating access to SQLite databases. Its two subpackages provide alternative connectivity options: via ADODB/SQLiteODBC and directly via the C-language API. My earlier project, SQLiteDB, is the predecessor of the SQLiteADO subpackage. The SQLite For Excel VBA module, in turn, served as an inspiration for the other major component of the library, SQLiteC (Fig. 1).
What are some alternatives?
excel-formula-print - VBA macro to print formulas with variable names
Rubberduck - Every programmer needs a rubberduck. COM add-in for the VBA & VB6 IDE (VBE).
QRCodeLibVBA - QR Code generator library in VBA
VBA-Better-Array - An array class for VBA providing features found in more modern languages
VBA-SQL-Library - Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.
VBA-ExtendedDictionary - Dictionary object that extends the Scripting.Dictionary
vba-macros - Some VBA macros for personal use
msaccess-vcs-addin - Synchronize your Access Forms, Macros, Modules, Queries, Reports, and more with a version control system.
pacellman - Pac-Man in Excel
Excel-Pomodoro-Timer - Excel Pomodoro Timer