Python ODBC

[Clayton Brown - Emmie Osawa]

I am trying a basic case of SQL Insert INTO an access databse using
python.
Can anyone point out why this does not work? Note: DSN works, SQL
works in SQL2000, TRACKS table exists, database = access 2000.

<CODE>
import dbi, odbc

sqlInsert = "INSERT INTO TRACKS (INTERNAL_ID) VALUES ('1472738')"
myconn = odbc.odbc('CD_DSN')
cursor = myconn.cursor()
cursor.execute(sqlInsert)
myconn.commit()
cursor.close()
myconn.close()
</CODE>


Error Produced:
cursor.execute(sqlInsert)
dbi.program-error: [Microsoft][ODBC Microsoft Access Driver] 
Could not find output table 'TRACKS'. in EXEC