db = 'C:\\Profit\\profit_a\\ARMM'
dsn = 'Provider=VFPOLEDB.1;Data Source=%s' % db
conn.Open(dsn)
cmd = win32com.client.Dispatch('ADODB.Command')
cmd.ActiveConnection = conn
cmd.CommandText = (
    """Select * from factura, reng_fac where factura.fact_num = reng_fac.fact_num AND factura.fact_num = 6099;"""
    )
rs, total = cmd.Execute()
while total:
    for x in range(rs.Fields.Count):
        print('%s --> %s' % (rs.Fields.item(x).Name, rs.Fields.item(x).Value))
rs.MoveNext()
total = total - 1
Чтение файлов DBF с помощью pyodbc