RSS category feeds

RSS site feeds

More

Home arrow Script Collection arrow Microsoft Access arrow Read from a Microsoft Access database with ADODB
Read from a Microsoft Access database with ADODB PDF Print E-mail

This example demonstrates how to read from a Microsoft Access database via AdoDB and Python/Pywin32. This code opens a test database and prints the names of the columns.

import win32com.client
 
connection = win32com.client.Dispatch(r'ADODB.Connection')
DSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=c:\\pfad\\testdb.mdb;'
connection.Open(DSN)
recordset = win32com.client.Dispatch(r'ADODB.Recordset')
recordset.Open('SELECT * FROM Auftraege', connection, 1, 3)
fields_dict = {}
for x in range(recordset.Fields.Count):
    fields_dict[x] = recordset.Fields.Item(x).Name
    print fields_dict[x], recordset.Fields.Item(x).Value
Last Updated ( Saturday, 16 June 2007 )
 
Next >

Feedback

Advertisement

Comments

  • Hello. How to connect with the currentControll er? May be using another service?... More...
  • Hi there ,I want to use this in my c# code .how can I do it please let me know.p... More...
  • I want to extract all the task information, durations, start date and end date o... More...
  • This code works very well for printing MS word file to prn. If I want print with... More...
  • Hello Roberto, that`s possible. Perhaps you should use the Pywin32 module or com... More...

Login Form






Lost Password?

My prefered Python IDE

My prefered Python editor is Pyscripter from MMExperts. It is not only an editor. Pyscripter is a full Python IDE including (remote) debugging, a class browser, and all other nice helpers which a full featured IDE needs.

Do you have a script for me ?

Do you have an interesting Python script which does some really cool thing on Windows ? Please post them to this site. It`s very simple - simply copy&paste it to this form. No login is requiered.

Hint: For syntax highlighting and correct Python intendation place your code between html tags <pre> and </pre>.

My prefered web framework

My prefered web framework for developing web applications is Django. Django calls itself The web framework for perfectionists with deadlines. It is a really fast, scalable and (thanks Python) the sexiest web framework of the world.