RSS category feeds

RSS site feeds

Home arrow Script Collection arrow Microsoft Access arrow Read from a Microsoft Access database with ADODB
Read from a Microsoft Access database with ADODB 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

Comments

  • Here is variant with win32con for buttons and icons: import ctypes from win32con... More...
  • Some trial and error let me to the following solution. # to click the second lin... More...
  • Can I use the method above to get past the "There is a problem with this website... More...
  • Can i use this code for simulate a pression of an hotkeys like "F2"? And if yes,... More...
  • Hi, I receive the following error when I try to excute the script ::::::::::::::... 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.