I've used sqlite from MS Access, using sqlite ODBC driver; just for fun though, havent done anything useful with it yet.
I don't know how, but it's easy to imagine Excel pulling data from DBs using some sort of interface (ADO maybe?). All you need is some code the implements that interface for SQLite.