在Python中访问JET（.mdb）数据库 [英] Accessing a JET (.mdb) database in Python

问题描述

有没有办法从Python访问JET数据库？我在Linux上。所有我发现是一个.mdb查看器在存储库，但它是非常错误的。感谢

Is there a way to access a JET database from Python? I'm on Linux. All I found was a .mdb viewer in the repositories, but it's very faulty. Thanks

推荐答案

MDB工具是一组开放源代码库和实用程序，以便于从MS Access数据库（mdb文件）导出数据，而不使用Microsoft DLL。因此，非Windows操作系统可以读取数据。或者，换句话说，它们是反向工程MDB文件的布局。

MDB Tools 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.

Jackcess 是一个纯Java库，用于从并写入MS Access数据库。它是来自健康市场科学公司的OpenHMS项目的一部分。它不是一个应用程序。没有GUI。这是一个库，专供其他开发人员使用来构建Java应用程序。

Jackcess is a pure Java library for reading from and writing to MS Access databases. It is part of the OpenHMS project from Health Market Science, Inc. . It is not an application. There is no GUI. It's a library, intended for other developers to use to build Java applications.

ACCESSdb 是一个JavaScript库，用于在Internet Explorer中动态连接和查询本地可用的Microsoft Access数据库文件。

ACCESSdb is a JavaScript library used to dynamically connect to and query locally available Microsoft Access database files within Internet Explorer.

Jackcess和ACCESSdb都比MDB工具更新，更加活跃并且有写支持。

Both Jackcess and ACCESSdb are much newer than MDB tools, are more active and have write support.

这篇关于在Python中访问JET（.mdb）数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！