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

  • You can see more python editor comparison: sparkledge.com/.../ (http://sparkledg... More...
  • I am getting below error SetWindowPos(wi nList[0],0,dRig ht/2,0,dRight/2,dBottom... More...
  • try using like this:- attachment1 = r"Path to attachment no. 1" More...
  • hi, can we write the python script as AutoIT interface to open tear term and sen... More...
  • parrondo.navarro@gmail.com Hi, Don't know if anyone still follows up on this but... 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.