Can somebody help me ?

[Patrick]

Hi,

I managed to open a msaccess database with python.

import win32com.client.dynamic
db1 = win32com.client.dynamic.Dispatch("Access.Applicati on")
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

[Roger Upole]

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" <pa****************@siemens.com> wrote in message
news:9f**************************@posting.google.c om...

Hi,

I managed to open a msaccess database with python.

import win32com.client.dynamic
db1 = win32com.client.dynamic.Dispatch("Access.Applicati on")
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

[Tor Iver Wilhelmsen]

pa****************@siemens.com (Patrick) writes:

import win32com.client.dynamic
db1 = win32com.client.dynamic.Dispatch("Access.Applicati on")

As an aside: This looks like a good candidate for import aliasing

import win32com.client.dynamic as com
db1 = com.Dispatch("Access.Application")

Unless you like to type a lot. :)

[beliavsky]

pa****************@siemens.com (Patrick) wrote in message news:<9f**************************@posting.google. com>...

Hi,

I managed to open a msaccess database with python.

You can help us by using an informative title such as "Open MSAccess
with Python?" instead of the generic "Can somebody help me?"