At 09:57 PM 12/5/2005, Gregorius Gede Wiranarada wrote: >hello, >how can i connect python to read data from ms access or ms foxpro?
foxpro: Install (if you have not) Mark Hammond's pywin32 to get the odbc module http://sourceforge.net/project/showfiles.php?group_id=78018 Create a Data Source (if you don't already have one) for the Visual FoxPro Driver. Call it VFP (or whatever). If you don't know what this means, ask. import odbc vfpconn = odbc.odbc(VFP) vfpcursor = vfpconn.cursor() vfpcursor.execute(sql) # this can be more complex, involving substitution parameters rows = vfp..cursor.fetchall() Also see http://www.python.org/windows/win32/odbc.html _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
