Modify values in an existing table of MS Access using Python

Question

I am trying to change a value of a whole column in MS Access database with python using pypyodbc. So far I have only found a way to create a new line but not modify the existing values.

This code is from another question I found and it works but only to create a new line (the table name is Table 1 and the column is Testie not that it really matters)

conn=pypyodbc.win_connect_mdb("C:\Users\y.johannes1\Documents\prufa.mdb")
cursor=conn.cursor()
sql= """ INSERT INTO Table1(Testie) Values(10)"""
cursor.execute(sql)
cursor.commit()
conn.close()

Any ideas?

Use an UPDATE Statement to change values in existing rows.

HansUp
– HansUp

2016-07-20 13:09:11 +00:00
Commented Jul 20, 2016 at 13:09 — HansUp
– HansUp, Commented Jul 20, 2016 at 13:09

A.Linnet · Accepted Answer · 2016-07-20 13:20:47Z

4

This worked if anyone has the same problem

conn=pypyodbc.win_connect_mdb("C:\Users\y.johannes1\Documents\prufa.mdb")
cursor=conn.cursor()
sql= """ Update Table1 SET testie=7 WHERE id=1"""
cursor.execute(sql)
cursor.commit()
conn.close()

answered Jul 20, 2016 at 13:20

A.Linnet

636 bronze badges

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

Collectives™ on Stack Overflow

Modify values in an existing table of MS Access using Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related