Can somebody help me ?

Roger Upole rupole at hotmail.com
Wed Aug 4 02:22:13 EDT 2004


You should be able to get at the data with something like this:

cdb=db1.CurrentDb()
rs=cdb.OpenRecordset('yourtablename')
while not rs.EOF:
    print rs.Fields(0)
    rs.MoveNext()

     hth
        Roger


"Patrick" <patrick.schaeffler at siemens.com> wrote in message
news:9f6a3388.0408031923.11cfa62d at posting.google.com...
> Hi,
>
> I managed to open a msaccess database with python.
>
> import win32com.client.dynamic
> db1 = win32com.client.dynamic.Dispatch("Access.Application")
> dbname = "D:\\Project\\Database\\database.mdb"
> db1.OpenCurrentDatabase(dbname)
>
> Now, I have the problem, that I don't know how I can read the lines
> of my table. Can somebody help me please and give me an example code ?
>
> I'm looking forward to your answers, and thank u very much in advance.
>
> Cheers
>
> Patrick





More information about the Python-list mailing list