conecting with a MsAcces DB by dao

luis solisgb at gmail.com
Fri Jun 30 08:50:08 CEST 2006


Hi
I'm using activestate python 2.4 on win xp 2 ed. and Ms Access 2002
(reading first http://starship.python.net/crew/bwilk/access.html)
I have writed the following code

def append_from_Access(self):
   try:
      import ...
      conn = win32com.client.Dispatch(r'ADODB.Connection')
      DSN = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA
SOURCE=C:/Afile.mdb;"
      conn.Open(DSN)
   except Exception, inst:
       ...
   try:
      sql_statement='SELECT * FROM  Mytable'
      rs = win32com.client.Dispatch(r'ADODB.Recordset')
      rs.Open(sql_statement, conn, 1, 3)
      while not rs.EOF:
         id=rs.Fields(colName.Value) #colName, valid column name
         ...
      rs.MoveNext()
      rs.Close()
      conn.Close()

     except Exception, inst:
         ...

I'm using it for reading tables or queries in a mdb file.
With some mdb it works fine and return a no empty recordset, but with
others mdb files, the recordsets are void (opening the tables or
recorsets with Ms Access are not void).
Some help is welcome,
Thanks in advance
Luis




More information about the Python-list mailing list