Mark Carter wrote:
>
>Consider the following snippet of code:
>
>import win32com.client
>
>DSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=M:\\Finance\\camel\
>\camel.mdb;'
>conn.Open(DSN)
>cursor = conn.Execute("UPDATE tblInvoice SET InvComments='Python'
>WHERE InvBillingPeriod = 'April 2010'
Consider the following snippet of code:
import win32com.client
DSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=M:\\Finance\\camel\
\camel.mdb;'
conn.Open(DSN)
cursor = conn.Execute("UPDATE tblInvoice SET InvComments='Python'
WHERE InvBillingPeriod = 'April 2010' AND InvJobCode = '2169'")
rows
