Write to a Microsoft Access database file with Python3

Question

For a school project I am to write and organize a set of data to a Microsoft Access database file. I am fairly comfortable with using python to read and write to files but can't find any information online regarding what I am specifically looking for.

I want to know what i would need to do to write to a database in specific Columns and Tables, for example, write the variable "name" in a field called "name" instead of just randomly adding it to the database.

EDIT: I cannot use any additional packages when doing this.

Hugh Bothwell · Accepted Answer · 2016-01-25 18:09:26Z

2

You can use PyODBC. Here is an example.

Edit: "no extra modules" is nice but unless you want to re-write pyodbc from scratch you may as well just use it.

Edit2: if you want to know what that would look like, check out pypyodbc - a pure-python odbc driver in about 3000 lines of Python code.

edited Jan 25, 2016 at 18:09

answered Jan 25, 2016 at 18:03

Hugh Bothwell

57k9 gold badges91 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Zunea Over a year ago

I am not allowed to actually implement separate modules into the program, is there no way to do it without or would simply writing like you would to a normal file (file.write(...)) work?

Hugh Bothwell Over a year ago

@Zunea: I would suggest getting the pypyodbc source code and copying over just the minimum bits your code needs to work (keep borrowed code in a separate section and attribute it properly, though!).

Collectives™ on Stack Overflow

Write to a Microsoft Access database file with Python3

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related