Small. Fast. Reliable.
Choose any three.
SQLite ODBC Driver (http://www.ch-werner.de/sqliteodbc/)

OpenSource BSD Licensed (Windows and Linux)

Note that this is in an experimental state and any feedback is appreciated.

So far it has been tested with SQLite 2.8.17 and SQLite 3.3.4 on Windows NT/2000 in MS Excel 97 (MSQUERY) with SQLite database files created on Linux. It also runs on Linux with unixODBC 2.{0,1}.x and with libiodbc 3.0.6.

Is there someone who could help with the integration of SQLite into OpenOffice 2?
(http://wiki.services.openoffice.org/wiki/SummerOfCode2006#Native_SQLite_driver)

Other Google Summer of Code 2006 ideas: http://code.google.com/soc/

I've updated the MSVC build files from the ODBC code to use SQLite 3.2.7. There is a bit more information and a zip file at http://www.patthoyts.tk/sqlite3odbc.html
20-Feb-2006: Updated to SQLite 3.3.4 and issued an updated archive.
Jan-2007: The primary sqliteodbc site now has more up-to-date versions (3.3.10). See http://www.ch-werner.de/sqliteodbc/



2008-03-15: (by Wm; this is my first contribution to this Wiki; review is welcomed)
In addition to the information above there is also an ODBC driver that comes as part of SQLite2008 Pro Enterprise Manager; see entry at http://www.sqlite.org/cvstrac/wiki?p=ManagementTools

re: integration w. OpenOffice (and carefully avoiding the politics):

Both the drivers mentioned above work fine with OOo 2.3 and SQLite3 on WinXPSP2 (Christian Werner's ODBC works on Win98SE too; I haven't tried either on Vista).

Using them is simple: create the ODBC connection in Win as usual; in OOo choose File / New / Database / Connect to an existing database / ODBC / Next / Browse / Pick your db from the list (using the data source name you gave it rather than the driver) / Next and Finish should see you through the rest of the process.