对于小团队在本地共享低强度数据，作者建议使用SQLite而非设置服务器。推荐通过OLE DB提供程序来访问SQLite数据库，并引用了两个资源：一个是SQLiteWrappers，另一个是已验证过的Sqlitex，这两个都可以在Excel中通过ADO或COM+DLL进行连接。
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/
7759
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
