Python读取Access数据并遍历某一列

import pypyodbc
p_path = r'D:2021-8-17-3-TIANJIN.mdb'
connStr = 'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ='+p_path+';PWD=007'
conn = pypyodbc.win_connect_mdb(connStr)  # 链接数据库
cur = conn.cursor()  # 创建游标
sql = "SELECt * FROM " + 'OriginalData'  # 取表 OriginalData
# print(sql)
cur.execute(sql)
alldata = cur.fetchall()  # 取表所有数据
total_rows = len(alldata)
total_cols = len(alldata[0])
print(""表:%s"总行数 = %d" %('OriginalData', total_rows))
print(""表:%s"总列数 = %d" %('OriginalData', total_cols))
# 遍历第六列数据
message = [x[6] for x in alldata]
for msg in message:
    decode_msg = msg[14:-8]    # 提取需要解析的字段
    ......
conn.close()  # 关闭数据库

Access数据库数据情况：