blocks|key|1344644|text|This+SO+question演示了使用它来读取MS+Access是可能的。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1344645|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/827502/pyodbc-and-microsoft-access-inconsistent-results-from-simple-query^0|0|G|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

How about <a href="http://code.google.com/p/pyodbc/" rel="nofollow noreferrer">pyodbc</a>? <a href="https://stackoverflow.com/questions/827502/pyodbc-and-microsoft-access-inconsistent-results-from-simple-query">This SO question</a> demonstrates it's possible to read MS Access using it.

blocks|key|1344915|text|您已经有了一些听起来不错的解决方案。另一个可能比您希望的更接近“金属”的工具是MDB工具。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1344916|MDB+Tools是一组开源库和实用程序，可在不使用Microsoft+DLL的情况下方便地从MS+Access数据库(mdb文件)导出数据。因此，非Windows操作系统可以读取数据。或者，换句话说，他们是在对MDB文件的布局进行逆向工程。|offset|length|1344917|还要注意的是，我怀疑他们是否已经开始处理ACCDB文件，而且可能不会有太多对该功能的需求。|1344918|entityMap|0|LINK|mutability|MUTABLE|url|http://sourceforge.net/projects/mdbtools/^0|0|0|9|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@$D|R|E|S|1|T]]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

You've got what sounds like some good solutions. Another one that might be a bit closer to the "metal" than you'd like is MDB Tools.

<a href="http://sourceforge.net/projects/mdbtools/" rel="noreferrer">MDB Tools</a> is a set of open source libraries and utilities to facilitate exporting data from MS Access databases (mdb files) without using the Microsoft DLLs. Thus non Windows OSs can read the data. Or, to put it another way, they are reverse engineering the layout of the MDB file. 

Also note that I doubt they've started working on ACCDB files and there is likely not going to be much request for that capability.

blocks|key|1560483|text|在Ubuntu+12.04上，我这样做是为了让它工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1560484|安装pyodbc：|1560485|$+sudo+apt-get+install+python-pyodbc|code-block|syntax|javascript|1560486|接下来安装一些额外的驱动程序：|1560487|$+sudo+apt-get+install+mdbtools+libmdbodbc1|1560488|制作一个连接到数据库并显示所有表格的小测试程序：|1560489|import+os
import+pyodbc

db_path+=+os.path.join("path",+"toyour",+"db.mdb")
odbc_connection_str+=+'DRIVER={MDBTools};DBQ=%25s;'+%25+(db_path)
connection+=+pyodbc.connect(odbc_connection_str)
cursor+=+connection.cursor()

query+=+"SELECT+*+FROM+MSysObjects+WHERE+Type=1+AND+Flags=0"
cursor.execute(query)
rows+=+cursor.fetchall()
for+row+in+rows:
++++print+row|1560490|我希望它能帮上忙。|1560491|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|10|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|11|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

On Ubuntu 12.04 this was what I did to make it work.

Install pyodbc:

<pre><code>$ sudo apt-get install python-pyodbc
</code></pre>

Follow on installing some extra drivers:

<pre><code>$ sudo apt-get install mdbtools libmdbodbc1
</code></pre>

Make a little test program which connects to the DB and displays all the tables:

<pre><code>import os
import pyodbc

db_path = os.path.join("path", "toyour", "db.mdb")
odbc_connection_str = 'DRIVER={MDBTools};DBQ=%s;' % (db_path)
connection = pyodbc.connect(odbc_connection_str)
cursor = connection.cursor()

query = "SELECT * FROM MSysObjects WHERE Type=1 AND Flags=0"
cursor.execute(query)
rows = cursor.fetchall()
for row in rows:
 print row
</code></pre>

I hope it helped.

blocks|key|1345030|text|就我个人而言，我从未能够让MDB工具(以及相关的ODBC工具，如unixODBC)在Linux下正确地使用Python或PHP，即使经过多次尝试也是如此。我只是尝试了这个问题here的另一个答案中的说明，我得到的只是“分割错误(核心转储)”。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1345031|但是，我确实让Linux驱动程序从UCanAccess或CPython%2BJayDeBeApi读取.mdb和.accdb文件。有关如何在Ubuntu14.04LTS下设置它的详细说明，请参阅我的另一个答案here。|1345032|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/24096474/2144390|1|http://ucanaccess.sourceforge.net/site.html|2|https://stackoverflow.com/a/25614063/2144390^0|2F|4|0|0|H|A|1|2T|4|2|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@$A|W|B|X|1|Y]|$A|Z|B|10|1|11]]|C|$]]|$1|F|3|-4|5|6|7|12|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]|P|$5|I|J|K|C|$L|Q]]]]

Personally, I have never been able to get MDB Tools (along with related ODBC stuff like unixODBC) to work properly with Python or PHP under Linux, even after numerous attempts. I just tried the instructions in the other answer to this question <a href="https://stackoverflow.com/a/24096474/2144390">here</a> and all I got was "Segmentation fault (core dumped)".

However, I did get the <a href="http://ucanaccess.sourceforge.net/site.html" rel="nofollow noreferrer">UCanAccess</a> JDBC driver to read both .mdb and .accdb files on Linux from either Jython or CPython+JayDeBeApi. For detailed instructions on how I set it up under Ubuntu 14.04 LTS see my other answer <a href="https://stackoverflow.com/a/25614063/2144390">here</a>.

blocks|key|1344747|text|最有可能的是，您希望使用像SQLAlchemy这样的优秀框架来访问您的数据，或者至少我会推荐您这样做。Support+for+Access是“试验性的”，但我记得使用它并没有太多问题。它本身使用幕后的pyodbc来连接访问dbs，所以它应该可以在windows，linux，os+x等操作系统上工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1344748|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sqlalchemy.org/|1|http://www.sqlalchemy.org/trac/wiki/DatabaseNotes#MicrosoftAccess|2|http://code.google.com/p/pyodbc/^0|D|A|0|1F|I|1|2S|6|2|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]|$A|T|B|U|1|V]|$A|W|B|X|1|Y]]|C|$]]|$1|D|3|-4|5|6|7|Z|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]|N|$5|G|H|I|C|$J|O]]]]

Most likely, you'll want to use a nice framework like <a href="http://www.sqlalchemy.org/" rel="nofollow noreferrer">SQLAlchemy</a> to access your data, or at least, I would recommend it. <a href="http://www.sqlalchemy.org/trac/wiki/DatabaseNotes#MicrosoftAccess" rel="nofollow noreferrer">Support for Access</a> is "experimental", but I remember using it without too many problems. It itself uses <a href="http://code.google.com/p/pyodbc/" rel="nofollow noreferrer">pyodbc</a> under the hood to connect to Access dbs, so it should work from windows, linux, os x and whatnot.

blocks|key|1344841|text|如果您使用EQL+Data将数据库同步到web，则可以使用JSON或YAML：http://eqldata.com/kb/1002查询Access表的内容。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1344842|这篇文章是关于PHP的，但它在Python中也同样适用。|1344843|entityMap|0|LINK|mutability|MUTABLE|url|http://eqldata.com/|1|http://eqldata.com/kb/1002^0|5|8|0|13|Q|1|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]|$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

If you sync your database to the web using <a href="http://eqldata.com/" rel="nofollow noreferrer">EQL Data</a>, then you can query the contents of your Access tables using JSON or YAML: <a href="http://eqldata.com/kb/1002" rel="nofollow noreferrer">http://eqldata.com/kb/1002</a>.

That article is about PHP, but it would work just as well in Python.

blocks|key|1560514|text|如果您有一些空闲时间，可以尝试修复和更新这个python类，它通过本地COM32客户端API：Extraction+and+manipulation+class+for+Microsoft+Access读取MS-Access+DB|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1560515|entityMap|0|LINK|mutability|MUTABLE|url|http://code.activestate.com/recipes/528868-extraction-and-manipulation-class-for-microsoft-ac/^0|1B|1I|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

If you have some time to spare, you can try to fix and update this python-class that reads MS-Access DBs through the native COM32-client API: <a href="http://code.activestate.com/recipes/528868-extraction-and-manipulation-class-for-microsoft-ac/" rel="nofollow">Extraction and manipulation class for Microsoft Access</a>

blocks|key|1560610|text|我在Windows下把Python连接到MS+Access的方法是这样的：Connect+to+MS+Access+with+Python。也许你可以在Win7上找到一些麻烦，所以我找到了一个解决方案：Solving+a+connection+between+MS+Access+and+Python+on+Windows+7|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1560611|我还没有尝试过在Linux下连接！|1560612|entityMap|0|LINK|mutability|MUTABLE|url|http://www.manejandodatos.es/2014/9/connect-ms-access-python|1|http://www.manejandodatos.es/2014/9/solving-connection-ms-access-python-windows-7^0|11|W|0|2T|1Q|1|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]|$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

The way I connect Python to MS Access under Windows is by using this way: <a href="http://www.manejandodatos.es/2014/9/connect-ms-access-python" rel="nofollow noreferrer">Connect to MS Access with Python</a>.
Maybe you can find some trouble on Win 7, so I found a solution: <a href="http://www.manejandodatos.es/2014/9/solving-connection-ms-access-python-windows-7" rel="nofollow noreferrer">Solving a connection between MS Access and Python on Windows 7</a>

I haven't tried connecting under Linux!

How can I access Microsoft Access databases in Python? With SQL?

I'd prefere a solution that works with Linux, but I could also settle for Windows.

I only require read access.

What do I need to read Microsoft Access databases using Python?

如何在Python中访问Microsoft access数据库？使用SQL？我更喜欢在Linux上工作的解决方案，但我也可以满足于Windows。我只需要读访问权。

问使用Python读取Microsoft Access数据库需要执行哪些操作？
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用Python读取Microsoft Access数据库需要执行哪些操作？EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用Python读取Microsoft Access数据库需要执行哪些操作？
EN