I am trying to do a simple shared database for a small workgroup of people, who use Excel for their data. I am thinking SQLite, because I don't really want to go server, as there are only 5 users and they're all local, and the database is very low intensity.
What's the best tool for accessing SQLite via Excel?
解决方案
Get yourself a OleDB provider for Sqllite, then connecting to the database you could use ADO (old school), or you could use a COM+ dll which you could activate via CreateObject()
a good place to start is http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
and one ive actually used before http://dimzon541.narod.ru/sqlitex/