[轉載]Gobán Saor - xLITE - Excel/Proto SQLite utility

xLITE - Excel/Proto SQLite utility

WORK IN PROGRESS……
xLite is VBA Module to allow access to the power of SQLite from within a VBA macro environment. A version exists for Excel and for Proto.

Proto Custom Module

http://www.protosw.com/mods/lib/view/446

Proto Examples

http://www2.gobansaor.com/xLite/Join Two Tables via SQLite.proto

http://www2.gobansaor.com/xLite/Join to External SQLite database.proto

VBA Code:

http://www2.gobansaor.com/xLite/xLite.zip

DLLs used:

SQLite VBA friendly wrapper SQLITE3.DLL from Pivotal Solutions. The ZIP contains both the source and the DLL. No COM component so no registry entries required, just needs to be placed on your PATH or in your current working directory. Dynamically loads the SQLITE3 library at runtime so to get the latest SQLite version just swap in a new SQLITE3.DLL, no compile necessary. Also supports Sqlite(2).

Pivotal Solutions link no longer works use http://www2.gobansaor.com/xLite/pssqlite.dll to download DLL

http://www.pivotal-solutions.co.uk/downloads/company/pssqlite.zip

To download the latest SQLITE3.DLL go to http://www.sqlite.org/download.html

For ease of deployment both DLLs along with a sample NWIND.DB (a sqlite version of the well known MSAccess Northwind database) can be downloaded from http://www3.gobansaor.com/xLite via a function within the xLite module. When the module fails to find PSSQLITE.DLL it will call this function and prompt you to download the files.

Or download from this site using the following links..

http://www2.gobansaor.com/xLite/pssqlite.dll

http://www2.gobansaor.com/xLite/sqlite3.dll

http://www2.gobansaor.com/xLite/Nwind.db