使用Python读取Microsoft Access数据库需要什么? [英] What do I need to read Microsoft Access databases using Python?

问题描述

如何使用Python访问Microsoft Access数据库?使用SQL吗?

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

我更喜欢可以在Linux上使用的解决方案，但我也可以选择Windows.

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

我只需要读取权限.

推荐答案

我使用了 PYODBC 成功连接到MS Access数据库-在Windows上.安装很容易，用法也很简单，您只需要设置正确的连接字符串(列表中提供了用于MS Access的连接字符串)，然后使用示例.

I've used PYODBC to connect succesfully to an MS Access db - on Windows though. Install was easy, usage is fairly simple, you just need to set the right connection string (the one for MS Access is given in the list) and of you go with the examples.

这篇关于使用Python读取Microsoft Access数据库需要什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！