如何在Microsoft Excel中访问SQLite数据库 [英] How can I access a SQLite database in Microsoft Excel
问题描述
我正在为一小群人使用简单的共享数据库,他们使用Excel作为数据。我在想SQLite,因为我真的不想去服务器,因为只有5个用户,他们都是本地的,数据库的强度非常低。
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.
通过Excel访问SQLite最好的工具是什么?
What's the best tool for accessing SQLite via Excel?
推荐答案
自己为Sqllite提供一个OleDB提供程序,然后连接到可以使用ADO(旧学校)的数据库,或者你可以使用COM + dll可以通过CreateObject()
a启动的好地方是 http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
和一个实际使用之前 http://dimzon541.narod.ru/sqlitex/
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/
这篇关于如何在Microsoft Excel中访问SQLite数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!