conecting with a MsAcces DB by dao

[luis]

Iain King ha escrito:

> luis wrote:
> > Iain King ha escrito:
> >
> > > luis wrote:
> > > >       while not rs.EOF:
> > > >          id=rs.Fields(colName.Value) #colName, valid column name
> > > >          ...
> > > >       rs.MoveNext()
> > > >       rs.Close()
> > > >       conn.Close()
> > >
> > > I don't know if it's the problem your asking about, but your
> > > rs.MoveNext() should be inside the while loop, no?
> > Yes, is inside
> > >
>
> You mean, it is inside the while loop in your code, but you made a
> mistake copying it into your post?  In the code you posted it is not
> inside the while loop - it would have to be indented one more level for
> that.
>
> Iain

this is te correct identation

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 think my problem must be with ado and dao.
Now I have run makepy utility and select Microsoft ActiveX Data Objects
2.5 Library, perhaps I must also select Microsoft DAO3.5 Object Library
and write
win32com.client.Dispatch("DAO.DBEngine.35") for Access 97 or
win32com.client.Dispatch(r'ADODB.Connection') for Acess 2000
Do you know is it possible ? 
luis