How to append a tuple full of records to a dbf file in Python?

[DarkCoder2020]

I'm trying to append a tuple full of records into a dbf file that I received from a sql statement but it only produce one record in my tuple. This is my code:

try:            
            DbConnect = '***'
            myDbConn = pymssql.connect("*********","********", "*************",DbConnect)
            cursor = myDbConn.cursor()
            cursor.execute("""select * from payrolldata where busdate>= %s and busdate<=%s ;""",(dteStartDate,m0weekend))
            rows = cursor.fetchall() or []

            for row in rows:
                myTup = tuple(row)



                Dbf = dbf.Table( 'microsdata.DBF', 'id N(7,0); StoNo C(4);BusDate C(20);Position C(20);Ssn C(11); R_HRS N(10,4); Ot_Hrs N(10,4); OthOt_Hrs N(10,4); Oth_Hrs N(10,4); Tips_Pd N(10,4); Tips_Chg N(10,4); Tips_Ind N(10,4); Tips_Dec N(10,4); FirstName C(20); LastName C(20); PayrollId C(10); PayRate N(10,4); RegPay N(10,4)') 
                Dbf.open(mode=dbf.READ_WRITE)
                records = Dbf.append(myTup)

[DPaul]

Could it be that you only receive the last record?
It seems to me that you are creating the same table in a loop over and over again.

Paul

[DarkCoder2020]

I put it in that loop because I thought it would loop all my records. When its outside my for loop it shows no records in my dbf file.

[DarkCoder2020]

I'm trying to append tuple into my dbf file as records but it only gets the last line of my tuple.

 table = dbf.Table( 'empInfo.DBF', 'SSN C(11); STOREID C(4);Payrollid C(10); EmpId C(10); Fname C(20); Lname C(20)') 
 table.open(mode=dbf.READ_WRITE)
 rec = tuple(rows)
 print(rec)

[DarkCoder2020]

I'm trying to append a tuple for multiple records but I only get the last record of my tuple.

table = dbf.Table( 'empInfo.DBF', 'SSN C(11); STOREID C(4);Payrollid C(10); EmpId C(10); Fname C(20); Lname C(20)') 
table.open(mode=dbf.READ_WRITE)

rec = tuple(rows)

table.append(rec)