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 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

  • What difference does this have with the SendKeys method from the "WScript.WShell... More...
  • 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...

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.