SQLite for Excel for Windows v.0.6


SQLite is a small, easy-to-use, open-source SQL database engine. SQLite for Excel is a lightweight wrapper to give access to the SQLite3 library from VBA. It provides a high-performance path to the SQLite3 API functions, preserving the semantics of the SQLite3 library calls and allowing access to the distributed SQLite3.dll without recompilation.The current release has the following parts: SQLite3_StdCall d-deOCt A small and very simple C .dll that makes it possible to use the standard SQLite3 .dll from VBA. It just passes calls from VBA on to SQLite without any change in the parameters, but this allows the StdCall calling convention that VB6 and VBA is limited to. Sqlite3.bas VBA module d-deOCt Has all the VBA Declares, and does the parameter and string conversions. It exposes a number of SQLite3xxxx functions. These map as directly as possible to the SQLite C API, with no change in the semantics. Although I have not exposed the whole API, most of the core interface is included, in particular the prepared statement, binding, retrieval and backup functions. Date values are stored as Julian day real numbers in the database. Sqlite3Demo.bas VBA module d-deOCt Has tests that serve as nice examples of how to use the SQLite3xxxx functions. SQLite3Demo.xls contains the two VBA modules.

SQLite is a small, easy-to-use, open-source ...

number, interface, module, string, serve

  • SQLite for Excel for Windows
  • 0.6
  • Govert van Drimmelen
  • WinXP, Win2003, Win2000, Win Vista, Window2008, Windows 7
  • Freeware
  • 516 Kb
  • 143
  • Free

Review SQLite for Excel for Windows

  • captcha
New Server Tools software
  • TSplus App  v.2.0Just like TSplus software, the TSplus App provides fast and stable remote connections from tablets and smartphones, to Windows desktops and business applications. It is designed on the same principles of security, simplicity and reliability ...
  • TSplus  v.11.70TSplus is the most simple and affordable alternative to Citrix for Remote Desktop Connections, Application Publishing, Client Generation and much more. Connect to your Remote Desktop with any Windows system, from any device and with any browser.
  • RDS Knight Ultimate Protection  v.3.3RDS-Knight is the right shield for your windows servers. In minutes you will prevent foreigners from opening a session, block brute force and ransomware attacks, restrict access by device and by time, and lock down your users environment.