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.
To access databases in Python, you'll need to use a database adapter. Python offers database adapters through its modules that allow access to major databases such as MySQL, PostgreSQL, SQL Server, and SQLite. Furthermore, all of these modules rely on Python's database API (DB-API) for managing databases.
Access uses Visual Basic for Applications (VBA) as its development language.
On Linux, MDBTools is your only chance as of now. [disputed]
On Windows, you can deal with mdb files with pypyodbc.
To create an Access mdb file:
import pypyodbc pypyodbc.win_create_mdb( "D:\\Your_MDB_file_path.mdb" )
Here is an Hello World script that fully demostate pypyodbc's Access support functions.
Disclaimer: I'm the developer of pypyodbc.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With