sql = "INSERT INTO #tmp (txt) VALUES (?)"
batchsize = 10
rows = []
for row in df.itertuples(index=False):
    rows.append(row)
    if len(rows) % batchsize == 0:
        crsr.executemany(sql, rows)
        rows = []
if len(rows) > 0:
    crsr.executemany(sql, rows)