Add new field to access table using python

Question

I have an access table that I am trying to add fields programmatically using Python. It is not a personal geodatabase. Just a standard Access database with some tables in it.

I have been able to access the table and get the list of field names and data types.

How do I add a new field and assign the data type to this Access table using Python.

Thanks! SRP

mechanical_meat · Accepted Answer · 2010-12-06 21:07:32Z

1

Using the pyodbc module:

import pyodbc

MDB = 'c:/path/to/my.mdb'
DRV = '{Microsoft Access Driver (*.mdb)}'
PWD = 'my_password'

conn = pyodbc.connect('DRIVER=%s;DBQ=%s;PWD=%s' % (DRV,MDB,PWD))
c = conn.cursor()
c.execute("ALTER TABLE my_table ADD COLUMN my_column INTEGER;")
conn.commit()
c.close()
conn.close()

Edit:
Using win32com.client...

import win32com.client
conn = win32com.client.Dispatch(r'ADODB.Connection')
DSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=c:/path/to/my.mdb;'
conn.Open(DSN)
conn.Execute("ALTER TABLE my_table ADD COLUMN my_column INTEGER;")
conn.Close()

edited Dec 6, 2010 at 21:07

answered Dec 6, 2010 at 19:57

mechanical_meat

170k25 gold badges237 silver badges231 bronze badges

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

3 Comments

debugged Over a year ago

Adam, Thanksfor your reply. I am using win32com.client module. Can you suggest w/ that?

debugged Over a year ago

I also added Microsoft ActiveX Data Objects 2.5 Library using MakePy utility

mechanical_meat Over a year ago

@debugged: win32com.client example added.

Collectives™ on Stack Overflow

Add new field to access table using python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related